SQL Server Performance Forum – Threads Archive
Sending mail with an attachment by reading Ntext.
Can any one help me with the code how to Send a mail with an attachment,from SQL Server. by reading a column which is of type ntext and another column file_type. This has to be done using SQL Server Stored Procedure. Following are the scenario Table Employee EmployeeId
File_type(Word or Excel or PPT or Outlook or any micrsoft supported types) File Type determines the type of the file to be sent as an attachments. mail_doc contains the actual contents of the document.
maybe this sample will help you up: http://www.sqldev.net/xp/xpsmtp.htm