SQL Server email notification issue

• srivathsani-296624

  Ten Centuries

  Points: 1208

  More actions

  January 25, 2006 at 12:32 am

  #152713

  I am sending email notifications once backup operations are completed from sql server using cdosys.In the text body ,i am using the token [A-MSG].I am getting the error

  Executed as user: sa. Line 8: Incorrect syntax near ''. [SQLSTATE 42000] (Error 170). The step failed.

  Plz help

• January 30, 2006 at 8:00 am

  This was removed by the editor as SPAM

• pavan-178969

  SSC-Addicted

  Points: 482

  More actions

  January 30, 2006 at 10:39 am

  #617777

  what for you are using token [A-MSG]?

  Are you using xp_sendmail for sending mail or xp_smtp_sendmail??