Debug Stored Proc's in MSSQL 2005

In SQL Server 2000's Query Analyzer, you can debug a stored procedure by right-clicking a SP and select "Debug".

You can then step through the SP one line at a time.

I don't see this in SQL Server 2005 and have searched but cannot find any documentation on what happened to this feature.
What did Microsoft do with this?

You can not debug Sp from SQL Server enviornment in 2005.... use Visual Studio

Ref :http://msdn2.microsoft.com/en-us/library/zxsa8hkf(VS.80).aspx

Madhu

|||

Thanks, I had seen that one before but didn't want to write it as managed code, so I stop short looking further. I did however, follow a few more links at the bottom and it brought me to the article:

How To: Step into an Object Using Server Explorer
http://msdn2.microsoft.com/en-us/library/ms165041(VS.80).aspx

Thanks!