| SQL Server Configuration Manager Help | |
| SQL Server Properties (Advanced Tab) | |
|
|
| SQL Server Configuration Manager Help > SQL Server 2008 Services > |
The following properties appear on the Advanced tab by default. If custom properties are defined, they also appear on this tab, with their values.
Options
- Clustered
-
Indicates if this service is installed as a resource of a clustered server.
- Customer Feedback Reporting
-
Indicates whether Service Quality Monitoring has been enabled on this service. For more information on Customer Feedback Reporting, search Books Online for the topic, "Error and Usage Report Settings."
- Data Path
-
Displays the path to the SQL Server binaries for this installation of SQL Server.
- Dump Directory
-
Displays the location where memory dumps are placed in case of an error.
- Error Reporting
-
When set to Yes, the Dr. Watson program forwards information to either Microsoft or your error server if a serious failure occurs. For more information on Error Reporting, search Books Online for the topic, "Error and Usage Report Settings." To change this value, in SQL Server Management Studio Object Explorer, right-click your server, click Properties, and then click the Misc. Server Settings page. The options are presented in the Information Reporting area.
- File Version
-
Displays the version of the SQL Server executable.
- Install Path
-
Displays the path to the SQL Server binaries for this installation of SQL Server.
- Instance ID
-
Indicates the SQL Server instance that used this service.
- Language
-
Displays the default language for server messages.
- Registry Root
-
Displays the location of the registry keys used by this application.
- Service Pack Level
-
Displays the service pack level of this instance of SQL Server.
- SKU Name
-
Displays the product stock keeping unit (SKU), sometimes called the product edition.
- Startup Parameters
-
Lists any startup parameters that are used by this instance of SQL Server. Parameters are separated by semi-colons. The default parameters include the paths to the data file for the master database (
master.mdf), the log file for the master database (mastlog.ldf), and the error log file. For the syntax of startup parameters, search Books Online for the topic Using the SQL Server Service Startup Options.
- Stock Keeping Unit
-
Displays the product stock keeping unit (SKU) number.
- Version
-
Displays the version number of this instance of SQL Server.
- Virtual Server Name
-
Virtual Server Name when SQL Server is installed on a clustered server.