SCRIPT to attach a log file

• ananthbhaskar

  Right there with Babe

  Points: 783

  More actions

  February 22, 2010 at 11:44 pm

  #143122

  Hi All,

  i have a small requirement, please help.

  i want to know how can i attach a file to the mail which i send through sqlmail,

  i mean i have a txt file which i have to attach to the alert mail which i send to all the recipants.

  Eg: i perform dbcc checkdb and store the result in a txt file and now i have to send it to a central mailbox,

  plz help me its urgent

  thanks

• ananthbhaskar

  Right there with Babe

  Points: 783

  More actions

  February 22, 2010 at 11:45 pm

  #1123442

  its sql server 2000

• MANU-J.

  SSC-Dedicated

  Points: 31126

  More actions

  February 23, 2010 at 2:19 pm

  #1123891

  Try @attachments parameter of xp_sendmail.

  http://msdn.microsoft.com/en-us/library/aa260697(SQL.80).aspx

  MJ