Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Resolving Errors in SQL Query Analyzer

Resolving Errors in SQL Query Analyzer

SQL Server 2000

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.
© 2015 Microsoft