Categories: MSDN / DotNet / Java / Scripts / Linux / PHP Ask - La ask - La Answer
Programmers Tech >> Developer Tech >> Database

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?
[687 byte] By [aish] at [2007-11-11 6:53:22]
«« Triggers....
»» Cant find the error
# 1 Re: EXECUTE permission denied on object sp_OACreate, database master, owner dbo.
Seems to me like you need to grant execute permissions for your user ID to the SQL Server objects you mentioned.
pclement at 2007-11-11 23:48:02 >
Developer Tech
Database

Developer Tech

All Classified

Developer Tech New Topic

Developer Tech Hot Topic