Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

How to: View Server Properties (SQL Server Management Studio)

The properties of an instance of SQL Server can be viewed in SQL Server Management Studio. Some properties are read-only, and some can be changed in SQL Server Management Studio. Some properties require restarting SQL Server to take effect.

Some property pages present information obtained via Windows Management Instrumentation (WMI). WMI must be installed on the computer running SQL Server Management Studio, to display those pages.

  1. In Object Explorer, right-click a server, and then click Properties.

  2. In the Server Properties dialog box, click a page to view server information about that page.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft