Hi friends, i have trying to make a procedure to send an email tom my
e-mail account using xp_smtp_sendmail, but y
have a problem and i don't know why i dont receive any message. I make ping
to the server and it works but when i run this:

declare @rc int
exec @rc = master.dbo.xp_smtp_sendmail
@FROM   = N'dep.tecn***@prmconsultores.com',
@TO   = N'dep.tecn***@prmconsultores.com',
@server       = N'smtp.prmconsultores.com'
select RC = @rc
go

the result of rc=1 and any message is send.

Someone can help me.

thanks in advance.

Sure, try to connect to the mailserver you are sending to. Use telnet
for this to clarify if the server accepts non-authenticated  relaying
(most productional server don´t do this).

-Open the commandline
-type: telnet <Servername> 25
-type: helo
-type: mailfrom:<YourMailAdress>
-type: rcptto:<ReceiptientMailAdress>
-type: data
-type: <two returns>

Mail will be send OR and error message will be presented (eventually
during the steps above).

Post the error back if any.

HTH, jens Suessmeyer.

Thanks for help. I have tried to make telnet

telnet smtp.prmconsultores.com 25

but it returns error like this:

connection error, can't open the connection to the host to 25 port

i think that the host don't accepts non-authenticated  relaying as yuo say.

thanks any way.

Sure, try to connect to the mailserver you are sending to. Use telnet
for this to clarify if the server accepts non-authenticated  relaying
(most productional server don´t do this).

-Open the commandline
-type: telnet <Servername> 25
-type: helo
-type: mailfrom:<YourMailAdress>
-type: rcptto:<ReceiptientMailAdress>
-type: data
-type: <two returns>

Mail will be send OR and error message will be presented (eventually
during the steps above).

Post the error back if any.

HTH, jens Suessmeyer.

Wait a minute, wait a minute. The attempt you made was just below the
application layer. So there might be a connection problem rather than a
authentification problem. "Denied relying" is presented when you
connect successfully to the remote computer and stated the command
above. If the server above is public you can be sure that unknown
mailservers are blocked. But a way around would be to install a virtual
SMTP server (like this one which comes with IIS) and relay the message
to a trusted mail server and then send it with credentials to a public
webserver.

HTH, jens Suessmeyer.

AWE and set working set size
Attaching SQL Server 2000 database on SQL Serve 2005
How can I get the message return?
Difference between 2000 and 2005. Maybe a bug?
sql2k log backup
user accounts after restore in SQL 2000
Collation Conflicts SQL 2005
Can't connect from ASP.Net 2.0 to SQL2000 after installing SQL2005
query performance with large tables
SQL Server Agent Jobs that are running