Tuesday, May 6, 2008
SQL server 2005 error and usage report
The SQL server install has an option to send error and usage reports to Microsoft. The option to send or not send is prompted during install. The screen presented during install is rather plain.
The option can be changed after installation is completed. In the programs menu select Microsoft SQL server 2005. Select Configuration tools in Microsoft SQL server 2005.In that select "Error and Usage Report Settings".
Details such as the location of error and usage reports can be specified for each of the different instances.
The error and usage reports can be sent only for a specific instance or all. You can also check the Privacy statement of SQL server 2005 from Microsoft in this screen.
However, will this report generation have a performance impact due to the extra overhead is something that is to be checked.