Friday, March 23, 2012

excuting xp_sendmail

When excuting the xp_sendmail in the Query analyzer, my mail gets send. When doing this in my code it doesn't work eventhough I explicitly use startmailn then xp_sendmail and then sp_stopmail? I think this is a problem of user rights? I gave my user as parameter but even then it didn't work. Any suggestions? I'm pretty sure, the used code is correct.

greetings,
Geoffhumm.

Make sure you configure both the server and the SQL Server Agent to send mail. You do this by specifying the mail profile and running a quick test.

No comments:

Post a Comment