June 15, 2004 at 9:43 am
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'.
June 15, 2004 at 9:54 am
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.
June 15, 2004 at 11:12 am
I do have the same username. I have 40+ stored procedures and each one has my username with full rights.
June 15, 2004 at 11:24 am
actualy i dont get that error anymore but all the buttons are disabled when i try to debbug.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply