March 18, 2011 at 7:24 am
If I have a maintenance plan (which runs everyday) which put out a report on index stat's and other DBCC information, The report come to me and other operators with the report information in the body of the email. How can I have the report come as an attachement instead? I tried sp_send_dbmail, I guess I'm using the wrong parameter.
March 18, 2011 at 9:02 am
See if this post helps: http://www.sqlservercentral.com/Forums/Topic341391-149-1.aspx
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 18, 2011 at 9:46 am
if you follow the link make sure your profile in database mail is set = @profile_name = 'ABC',
other wise it will fail
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply