SQL Query Analyzer had a neat debug facility for Stored Procedures in SQL 2000. It went missing in SSMS 2005 but at least we could use the Visual Studio debug facility for both .NET and Transact-SQL ...