Export (0) Print
Expand All

Error Reporting (SQL Server)

SQL Server 2000

  New Information - SQL Server 2000 SP3.

Microsoft® SQL Server™ error reporting is turned off by default. Enable it during installation through SQL Server Setup, or after installation through the SQL Server Enterprise Manager Server Properties dialog box. Enabling it during SQL Server Setup allows error reporting for the SQL Server database engine and SQL Server Agent.

If you enable this feature, SQL Server will be configured to automatically send a report to Microsoft if a fatal error occurs in the SQL Server database engine or SQL Server Agent. Microsoft uses error reports to improve SQL Server functionality, and treats all information as confidential.

Information about the error will be sent over a secure (https) connection to Microsoft, where it will be stored with limited access. Alternatively, this information can be sent to your own Corporate Error Reporting server. See this Microsoft Web site for more information about setting up a Corporate Error Reporting server.

  • The error report contains the following information:

  • The condition of SQL Server when the problem occurred.

  • The operating system version and computer hardware information.

  • Your Digital Product ID, which could be used to identify your license.

  • Your computer's IP network address.

  • Information from memory or file(s) of the process that caused the error.

Microsoft does not intentionally collect your files, name, address, e-mail address, or any other form of personal information. The error report may, however, contain customer-specific information from the memory or file(s) of the process that caused the error. Although this information could potentially be used to determine your identity, Microsoft does not use this information for that purpose.

For the Microsoft error reporting data collection policy, see this Microsoft Web site.

After you have enabled error reporting and a fatal error has occurred, you may see a response from Microsoft in the Windows Event log that points to a Microsoft Knowledge Base article on a particular error. A response may look similar to this example:

Source = MSSQLServerOlapServicesDW

EventID = 1010

data = http://support.microsoft.com/support/misc/kblookup.asp?id=.

To disable error reporting for the SQL Server database engine and SQL Server Agent, go to SQL Server Properties (General Tab) in Enterprise Manager and clear the Enable the error reporting feature checkbox.

© 2015 Microsoft