Home Forums SQL Server 2008 SQL Server 2008 - General Permission denied on the object sp_send_dbmail (but, not what you think) RE: Permission denied on the object sp_send_dbmail (but, not what you think)

  • May 21, 2012 at 9:41 am

    #1490498

    I think you could have also used

    @execute_query_database = Product_Database

    instead. it would have caused the sp_send_dbmail to change the database before executing the query.


    --Mark Tassin
    MCITP - SQL Server DBA
    Proud member of the Anti-RBAR alliance.
    For help with Performance click this link[/url]
    For tips on how to post your problems[/url]