extended stored procedure sp_sdidebug is missing

Hello,
I like to debug stored procedures, but the sp_sdidebug extended stored
procedure is missing on my server (master database). How can I recreate
this procedure?
You wont be able to find this SP in master. It is used to turn on or off TSQL
debugging. There is no user interface for it and no documentation.
Just try to execute it as,
Exec sp_sdidebug 'LEGACY_ON'
And again if you are not able to run try to grant permissions to that stored
procedure for the calling user.
In the SQL Analyzer type: GRANT EXECUTE ON sp_sdidebug TO <user here>
Ref : http://www.mcse.ms/archive109-2004-9-1116387.html
Thanks,
Sree
"Jack" wrote:

> Hello,
> I like to debug stored procedures, but the sp_sdidebug extended stored
> procedure is missing on my server (master database). How can I recreate
> this procedure?
>
|||Jack,
One more thing to add,
If it is not in the Extended Stored Procedures object you are out of luck
and you will have to reinstall SQL Server.
Thanks,
Sree
"Jack" wrote:

> Hello,
> I like to debug stored procedures, but the sp_sdidebug extended stored
> procedure is missing on my server (master database). How can I recreate
> this procedure?
>
|||> If it is not in the Extended Stored Procedures object you are out of luck
> and you will have to reinstall SQL Server.
I don't think reinstall would be necessary. Search for the script files in the install folder to see
how the call to sp_addextendedproc should look like.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Sreejith G" <SreejithG@.discussions.microsoft.com> wrote in message
news:AF10B4D8-2F7E-4F52-96C9-973E69A7186F@.microsoft.com...[vbcol=seagreen]
> Jack,
> One more thing to add,
> If it is not in the Extended Stored Procedures object you are out of luck
> and you will have to reinstall SQL Server.
> Thanks,
> Sree
> "Jack" wrote: