Export (0) Print
Expand All

Using Error Reporting

SQL Server 2000

  New Information - SQL Server 2000 SP3.

Microsoft® SQL Server™ now provides error reporting functionality in Service Pack 3. If you enable this feature, SQL Server automatically sends a report to Microsoft if a fatal error occurs in the SQL Server database engine, SQL Server Agent, or SQL Server Analysis Services. Microsoft uses error reports to improve SQL Server functionality, and treats all information as confidential.

Note  Error reporting is turned off by default.

Information about the error is sent over a secure (https) connection to Microsoft, where it is 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.

You can enable error reporting during installation through SQL Server Setup or Analysis Services Setup, or after installation through the SQL Server Enterprise Manager Server Properties dialog box or the Analysis Manager Server Properties dialog box. Enabling it during SQL Server Setup allows error reporting for the SQL Server database engine and SQL Server Agent; enabling it during Analysis Services Setup allows error reporting for Analysis Services. If you wish to enable error reporting for both SQL Server and Analysis Services, you must enable error reporting for SQL Server during SQL Server Setup, and enable it again for Analysis Services during Analysis Services Setup, or enable error reporting through Analysis Manager and SQL Server Enterprise Manager as described above.

If you have error reporting enabled 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 turn off error reporting for the SQL Server database engine and SQL Server Agent, go to the General tab of the SQL Server Properties dialog box in Enterprise Manager and clear the Enable the error reporting feature check box. To turn off error reporting for Analysis Services, go to the Error Reporting tab of the Properties dialog box in Analysis Manager and clear the Enable the error reporting feature check box. If you have error reporting turned on for both SQL Server (database engine and SQL Server Agent) and Analysis Services, and you wish to turn it off for both, you must turn off error reporting in both places.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft