Debug Sql Server 2005 Stored Procedure in Sql Server Management St

I am trying to figure out how to debug a Stored Procedure (SP) from Sql
Server Management Studio. Like in Query Analyzer in Sql Server 2000, where I
could right click an SP and then click debug on it will let me debug the SP.
Of course, I would execute sp_sdidebug 'legacy_on' before doing that.
In Sql Server Management Studio I do not see an option for debugging an SP
when I right click the SP nor do I see debugging SP option in the menu. I
read BOL, and it mentions to run sp_sdidebug. I tried to run sp_sdidebug but
I get "Could not find stored procedure sp_sdidebug". I tried this step in
master DB, user DB, and msdb but all give me the same error.
The user who is trying to debug the SP is already a member of symin role.
I can debug the SP from Visual Studio 2005, but I would like the same
capability I had in Sql 2000 to be in SMSS. Besides, the Results windows in
SMSS gives me resultset, which I cannot get from the Visual Studio, if I use
VS for debugging.
I have also read that many of the features, such as debugging, xp_cmdshell
etc. come disabled by default in SQL 2005, which is okay. But could somebody
tell me how to make the entire Stored Procedure debugging process work from
within SSMS?
Reply appreciated.
Thanks>I am trying to figure out how to debug a Stored Procedure (SP) from Sql
> Server Management Studio.
Can you please post to the SQL Server 2005 newsgroups.
http://www.aspfaq.com/sql2005/show.asp?id=1