XP_Sendmail??

  • Hi,

    Im facing a problem, please provider me the solution..

    Im using master.xp_sendmail 'recipients', 'test'

    I recvd the message ...... Mail Sent.

    but no email recvd in my inbox. what should be the reason???

    Waiting for your kind response..

    Thanx,

    Noman

  • Hi,

     Note: XP_SENDMAIL will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature..

    To send mail from SQL Server, use Database Mai i.e. XP_SEND_DBMAIL.

    for more information pls check below link

    http://msdn2.microsoft.com/en-us/library/ms175887.aspx

    Regards,

    Anand.

  • using an smtpsendmail proc works well too.......I prefer them as most of my environments do not allow sql mail to be set up.

  • how can i get this proc

    smtpsendmail ?? if u have the script ..plz paste it.

     

    Thanx

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

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