Debugging in SQL Management Studio
One common frustration is trying to debug SQL queries using the built-in editor within Microsoft SQL Server 2005 Management Studio. The database will kindly inform you of any errors when you attempt to execute a query, and also provide a line number. But that’s about it.
Compared to the error highlighting features available in Visual Studio, [...]