Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

EXECUTE permission denied (Stored procedure debugging) Expand / Collapse
Author
Message
Posted Tuesday, June 15, 2004 9:43 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, June 18, 2004 2:24 PM
Points: 3, Visits: 1

Guys I am getting this error when I try to debug a stored procedure using Query Analyzer:

Server: Msg 229, Level 14, State 5, Procedure sp_sdidebug, Line 1[Microsoft][ODBC  SQL Server Driver][SQL Server]EXECUTE permission denied on object 'sp_sdidebug', database 'master', owner 'dbo'.

I only get this error whe I run Query analyzer from my PC, when I log onto the server itself everything works fine. I have administrative for everything on my network.

Help please. thanks.

Post #121153
Posted Tuesday, June 15, 2004 9:54 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, August 10, 2007 8:08 AM
Points: 12, Visits: 1

It sounds like you are not using exactly the same username that your using on the server.  For instance, you might be using sa on the server and windows authentication on the machine thats not letting you run your stored procedure.

Just want to cover the basics:

Double check the username you are using on your PC, and make sure in enterprise manager that you have given yourself execute permissions on the stored procedure.

 

Post #121157
Posted Tuesday, June 15, 2004 11:12 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, June 18, 2004 2:24 PM
Points: 3, Visits: 1
I do have the same username. I have 40+ stored procedures and each one has my username with full rights.
Post #121170
Posted Tuesday, June 15, 2004 11:24 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, June 18, 2004 2:24 PM
Points: 3, Visits: 1
actualy i dont get that error anymore but all the buttons are disabled when i try to debbug.
Post #121173
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse