I used to use the debug feature in Query Analyzer when working with SQL Server 2000 quite a lot. There were a number of time when I did want to do this in SQL Server 2005 but couldn't quite figure it out. I looked high and low on SQL Server Management Studio to no avail.
The reason? Debugging was moved out of SQL Server Management Studio and into Visual Studio.
Read all about it in this article by Scott Mitchell.