xp_sendmail with no subject

• Bidec

  SSCommitted

  Points: 1666

  More actions

  April 30, 2004 at 8:37 am

  #161470

  Hi All,

  I am running SQL 2000 ( 8.00.818 ) on Windows 2003 ( NT 5.2 (3790)). When I try to run :

  xp_sendmail 'myid@domain.com' , @subject = 'subject'

  I do get an email but the 'subject' is missing. Has anyone seen this kind of problem ?  Do we have any workaround for this one ?

  The version for SQLMAP70.DLL is :

  2000.80.811.0

  Any help is appreaciated.

  Thanks.

• Rodrigo Acosta

  SSC-Insane

  Points: 21261

  More actions

  April 30, 2004 at 3:22 pm

  #504908

  Try executing the xp with named parameters like this:

  EXEC master.dbo.xp_sendmail @recipients = 'myid@domain.com' , @subject = 'subject'

• Bidec

  SSCommitted

  Points: 1666

  More actions

  May 12, 2004 at 9:17 am

  #506162

  Thanks racosta..

  But even that didn't work. So finally I had to rollback to the older version (Outlook 2002) and now it is working fine.