|
-
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?
-
Seems to me like you need to grant execute permissions for your user ID to the SQL Server objects you mentioned.
Paul
~~~~
Microsoft MVP (Visual Basic)
Similar Threads
-
By Arjuna in forum Database
Replies: 2
Last Post: 07-25-2007, 03:22 AM
-
By Ronald Aranha in forum Database
Replies: 3
Last Post: 08-29-2001, 12:14 PM
-
By Ted Tracy in forum Database
Replies: 0
Last Post: 11-13-2000, 04:50 PM
-
By Tom Shreve in forum Enterprise
Replies: 1
Last Post: 05-04-2000, 10:10 PM
-
By Tom Shreve in forum Enterprise
Replies: 0
Last Post: 04-07-2000, 08:15 PM
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Development Centers
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center
|
Reply With Quote
