Results 1 to 3 of 3

Thread: EXECUTE permission denied on object 'sp_OACreate', database 'master', owner 'dbo'.

  1. #1
    Join Date
    Sep 2005
    Posts
    2

    EXECUTE permission denied on object 'sp_OACreate', database 'master', owner 'dbo'.

    I want to send email using sql stored procedure.my code is work fine in my local sqlserver account. when I use my online sql server it display this error.

    EXECUTE permission denied on object 'sp_OACreate', database 'master', owner 'dbo'.

    EXECUTE permission denied on object 'sp_OASetProperty', database 'master', owner 'dbo'.

    EXECUTE permission denied on object 'sp_OAMethod', database 'master', owner 'dbo'.

    EXECUTE permission denied on object 'sp_OADestroy', database 'master', owner 'dbo'.

    How canI solove this problem?

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    You may have sysadmin rights on your local sql server but not on remote one, ask dba of that server to check your permission.

  3. #3
    Join Date
    Sep 2005
    Posts
    2
    Thank you for help

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •