sp_sdidebug Error | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

sp_sdidebug Error

Hi All, When I am debugging a stored procedure through Visual studio.Net or with Sql Server 2000 For VS.Net I am getting, "User does not have permission to execute master.sp_sdidebug" error. For Sql Server 2000 I am getting, " 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’."
With regards Aruna Mathew
For debugging a procedure i guess firstly you need to have SQL Service run as particular user and not as local system account.
And then by using that user creadential you can debug.
Also refer to thishttp://www.windowsitpro.com/Article/ArticleID/45573/45573.html link. Satya SKJ
Contributing Editor & Forums Moderator
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.