XP_Sendmail??

• Noman Tariq

  SSCommitted

  Points: 1750

  More actions

  February 28, 2006 at 11:46 am

  #67276

  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

• Anand Mohan

  SSC Enthusiast

  Points: 137

  More actions

  March 1, 2006 at 9:57 pm

  #624187

  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.

• Scorpion_66

  SSCertifiable

  Points: 7891

  More actions

  March 2, 2006 at 1:39 pm

  #624461

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

• Noman Tariq

  SSCommitted

  Points: 1750

  More actions

  March 3, 2006 at 10:25 am

  #624674

  how can i get this proc

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

   

  Thanx