Tips for using SQL Server's Query Analyzer

(1) When you receive an error in Query Analyzer, you can double-click on the error to be taken directly to the line of T-SQL code that caused the error to occur.

(2) Select a line of code, stored procedure name, or T-SQL statement and press SHIFT+F1 to go to T-SQL help for that statement, function, or procedure.

(3) Try pressing CTRL+R to quickly toggle between full-screen view and cascade view in the query pane.