|
|
|
Forum Newbie
      
Group: General Forum Members
Last Login: Monday, March 23, 2009 8:12 PM
Points: 1,
Visits: 2
|
|
[QUOTE=aish]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?[/QUOTE]
Please let me do fastly.
|
|
|
|
|
SSC Journeyman
      
Group: General Forum Members
Last Login: Wednesday, June 09, 2010 9:55 AM
Points: 77,
Visits: 104
|
|
I'll state the obvious. Are you sure that the Online SQL Server Account has permissions to execute the stored Procedures? If the account doesn't have high enough permissions to allow execute of all procedures, you may want to check the permissions of the user to see if it has been granted Execute on those SP's. TJP8
|
|
|
|