Can the name of a file attached to mail be changed in MSSQL?

• Manjusha H

  Newbie

  Points: 7

  More actions

  May 15, 2007 at 5:22 am

  #68665

  Hi,

  I will be taking multiple files from a folder and sending them to a mail ID one by one. But when sending, the name of the file should become the subject of the mail and the name of the attached file should also be changed. All the files should have the same name when attached to mails. Can this be done using stored procedures in MSSQL? 

  This is very urgent . Please help me out.

  Regards,

  MH

• Paul Mu

  SSCertifiable

  Points: 5547

  More actions

  May 15, 2007 at 7:46 am

  #706488

  You can use the extended SP xp_cmdshell to execute DOS commands to perform file operations such as copy, delete and rename, etc.

  Paul