Unanswered: sp_send_dbmail, attache a file on file system - HOW?
Is there any way to attach a file on the file system from sp_send_dbmail?
@body='Report saved to: D:\reports\purge_WFINSTANCE.txt ',
@subject ='MS-ALERT- TREKSPBDSQL.monte_prod: purge_WFINSTANCE run details',
the xp_cmdshell runs the bat file which ivokes sqlcmd with results posted to a local file system. The job works, but I'd like the results (counts) emailed to all dba's.