Edit

SQL Server Properties (Advanced Tab)

  • Article

Applies to: SQL Server - Windows only

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.