The title to the thread pretty much describes what I am getting stuck at. I was able to create a procedure successfully, but everytime I try to execute it, I get an error:
The EXECUTE permission was denied on the object 'sp_OACreate', database 'mssqlsystemresource', schema 'sys'.
Logically speaking, if the DB admin has granted me permission to create SPs, wouldn't he have granted me permission to execute them too? Below is how I am calling the SP:
USE [myDBName] GO DECLARE @return_value int EXEC @return_value = [dbo].[sp_SMTPMail] @SenderName = N'John', @SenderAddress = Nfirstname.lastname@example.org', @RecipientName = N'Jane', @RecipientAddress = Nemail@example.com', @Subject = N'Test SP Execution', @Body = N'Testing 1-2-3', @MailServer = N'smtp.example.com' SELECT 'Return Value' = @return_value GO
(Of course, all the values above - including the MailServer attribute - are fake)
How do I get around this? Am using MS SQL Server 2005