Reporting Errors

If you are unable to resolve a problem using the procedures described in Chapters 21 through 25 and in the Microsoft SQL Server Transact-SQL Reference, call your primary support provider for assistance. When you report an error to your primary support provider, be sure to have the following information:

• The environment in which the error occurred, including:
  • SQL Server version (as reported to the error log or returned by
    SELECT @@VERSION)
  • DB-Library API version (as reported by the Client Configuration Utility) or ODBC driver version (as reported by ODBC Driver Setup)
  • Front-end application version (for example, SQL Enterprise Manager or ISQL.EXE)
  • Operating-system version
  • Hardware platform
  • Production or development environment
• The message number, the message state, and the complete error message text
• Any variables (numbers, database object types, or database object names) included in the error message
• The context in which the message was generated (what statement was running at the time)
• The number of users who were logged in to SQL Server when the error occurred
• The frequency with which the error occurs

It is also helpful to provide a hard copy of the entire error log, including all messages displayed from startup to immediately before or after the error occurred.