SQL Mail

  • 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.

  • 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

  • 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