Post reply

xp_smtp_sendmail

  • June 16, 2009 at 4:05 am

    #201406

    Hi guys,

    I new to using xp_smtp_sendmail

    The exteneded stored procedure has been registered. I have ran the proc using the ping parameter and that returns 0 so that's ok.

    However, when I try and send an email to myself from sql server, I get a return value of 0 (success) but I do not actually ever recieve the email.

    Anybody got any suggestions on how I can determine the problem?

    Any help would be greatly appreciated

    Cheers

    Matt

  • June 14, 2011 at 2:01 am

    #1338194

    Is there any specific reason you are using xp_smtp_sendmail? If you are using 2005 or 2008 server then you can use msdb.dbo.sp_send_dbmail. This procedure automatically logs your mails. It becomes lot easier for you to keep a track.

  • July 3, 2011 at 7:32 am

    #1347536

    Agreed, you should use sp_send_dbmail:

    http://msdn.microsoft.com/en-us/library/ms190307.aspx[\url]

    You will need to configure a mail profile before you can use it:

    http://msdn.microsoft.com/en-us/library/ms189879.aspx[\url]

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply