Post reply

Procedure Execution Error in user DB

  • July 3, 2011 at 10:30 pm

    #253814

    Msg 15517, Level 16, State 1, Procedure SP_SEND_DBMAIL, Line 0

    Cannot execute as the database principal because the principal "dbo" does not exist, this type of principal cannot be impersonated, or you do not have permission.

    What i do..?

  • July 3, 2011 at 11:07 pm

    #1347620

    Coolroof (7/3/2011)

    Msg 15517, Level 16, State 1, Procedure SP_SEND_DBMAIL, Line 0

    Cannot execute as the database principal because the principal "dbo" does not exist, this type of principal cannot be impersonated, or you do not have permission.

    What i do..?

    Hi,

    Exec as

    exec msdb.dbo.sp_send_dbmail(pass required set of parameters)

    see BOL for set of parameters

    Regards

    Ashok

  • July 3, 2011 at 11:13 pm

    #1347621

    ya thaks working

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply