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

  • May 21, 2012 at 8:25 am

    #1490450

    since it's just this one server,

    could it be something like database mail is not emabled, even though you've created the profile?

    it sounds like maybe you scripted the database mail settings out and ran them, but not the configure?

    http://msdn.microsoft.com/en-us/library/ms191189.aspx

    use master
    go
    sp_configure 'show advanced options',1
    go
    reconfigure with override
    go
    sp_configure 'Database Mail XPs',1
    go
    sp_configure 'SQL Mail XPs',0
    go
    reconfigure
    go

    • This reply was modified 5 years ago by  Lowell.
    • This reply was modified 4 years, 8 months ago by  Lowell.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!