Category: sql server notification
sanjay devaraj on Thu, 07 Feb 2013 03:49:52
How to send table data as attachment in excel format from Stored procedure to predefined mail id.
RohitGarg on Thu, 21 Feb 2013 19:30:58
YOu can use sp_makewebtask system store procedure or bcp out or SSIS to genrate Excel file.
After that you can parameter @file_attachments of sp_send_dbmail store procedure to send excel with mail alert