Resolving Errors in SQL Query Analyzer

SQL Query Analyzer provides several tools to help you prevent and resolve errors.

• Use the color-coding in the Editor pane to help eliminate errors.

  Using the default colors as examples, if you type a keyword not displayed in blue, the keyword may be misspelled. If much of your code is displayed as red, you might have omitted the closing quotation mark for a character string.

• To parse syntax without executing the code, click the Parse button.
  
  
• If an error occurs, double-click the error message to locate the line that contains the error in your code.
  
  
• To debug stored procedures, use the Transact-SQL Debugger.