Direct Debugging with Query Analyzer

Using the Query Analyzer application that comes with SQL Server 2000, you can debug stored procedures running on either SQL Server 2000 or SQL Server 7.0. I'm not going to spend any time discussing this because it's not .NET related , but it's useful to know at least one neat debugging trick that you can perform with Query Analyzer that I haven't seen available elsewhere. The Auto Rollback command lets you automatically roll back all work performed by a stored procedure that you've been debugging. Apart from this, the debugger provides you with its own window that contains separate output panes for local variables (those prefixed with @), global variables (those prefixed with @@), the call stack, and the result of the query.