November 7, 2006 at 3:08 am
hello everyone,
i have a Stored prosedure whenever i start to debug that SP on my database in SqlServer 2000.
Server give me the following message abt permission:
"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'. "
plz tell me how i solve this problemn how i able to debug my SP in SqlServer 2000
November 7, 2006 at 11:18 am
Select user_name()
That will give you the current context of the connection... Make sure that this user has execute permission on the proc.
November 7, 2006 at 12:15 pm
To use the stored procedure debugger, you need to use RDP or login locally to do it. If you run it from a linked server, you may have this error.
November 8, 2006 at 8:51 am
If you are really trying to debug your procedure, then you may also want to try just running a sp_helptext against it. Then you can take the text returned by the sp_helptext proc so that you can work on isolating the lines that are causing the error, because trying to simply execute the stored proc probably won't get you very far in your debugging. You'll probably need to look at the text of the stored proc in order to solve the problem.
You can run sp_helptext with a permission level lower than SA so you shouldn't run into any permission errors when you try to execute it.
November 8, 2006 at 9:10 am
As Ninja's RGR'us stated, you need to have execute on the sp_sdidebug procedure. This is the first step. You may also want to verify that your local version of SQL and server version of SQL are the same. I have noticed problems if they are out of synch.
But, you definitely need access to the sp_sdidebug proc first.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply