xp_sendmail

[mici]

I used this very simple code :

EXEC xp_sendmail @recipients = 'xxx@hotmail.com',
@subject = 'hello' ,
@message = 'The contents of INFORMATION'

I RUN IT IN QUERY ANALYZER AND I GET A MESSAGE "Mail Sent"
However when i check my inbox I don't get the message.
What could be the problem?
(I set a mail profile on the sql server using outlook client.
I have no problem reading mails from my inbox by using read mail).

 

[bartsimpson]

Does the server send mail at all ? The email profile has to be set up to be the same user name as that that starts the SQL server. You then select the profile from Support Services, SQL Mail in Enterprse manager.

 

[mrdenny]

Make sure the Outlook is actually working. The message might be sitting in the outbox. Are you using a smtp server or exchange?

You also might want to look at xp_smtp_sendmail. You can google for it to find it.

Denny

--Anything is possible. All it takes is a little research. (Me)