SQL Server
United States (English) Sign in
Home 2012 2008 R2 2008 Previous Versions Library Forums
TechNet Library
SQL Server
SQL Server 2005
Product Documentation
SQL Server 2005 Documentation
SQL Server 2005 Books Online
SQL Server Database Engine
Database Engine How-to Topics
Administration How-to Topics
Server Management How-to Topics
Server Configuration How-to Topics
How to: View Server Properties (SQL Server Management Studio)
How to: Check and Set Remote Server Connection Options (SQL Server Management Studio)
How to: View or Change Server Properties (SQL Server Configuration Manager)
How to: Configure the Affinity Mask (SQL Server Management Studio)
How to: Configure the allow updates Option (SQL Server Management Studio)
How to: Configure the awe enabled Option (SQL Server Management Studio)
How to: Configure the c2 audit mode Option (SQL Server Management Studio)
How to: Configure the cost threshold for parallelism Option (SQL Server Management Studio)
How to: Configure the cursor threshold Option (SQL Server Management Studio)
How to: Set the Default Full-Text Language (SQL Server Management Studio)
How to: Set the Default Language (SQL Server Management Studio)
How to: Set a Fixed Fill Factor (SQL Server Management Studio)
How to: Configure the index create memory Option (SQL Server Management Studio)
How to: Configure the locks Option (SQL Server Management Studio)
How to: Configure the Number of Processors Available for Parallel Queries (SQL Server Management Studio)
How to: Set Minimum Query Memory (SQL Server Management Studio)
How to: Configure the Maximum Number of Worker Threads (SQL Server Management Studio)
How to: Set the Backup Retention Duration (SQL Server Management Studio)
How to: Set a Fixed Amount of Memory (SQL Server Management Studio)
How to: Configure the max text repl size Option (SQL Server Management Studio)
How to: Configure the nested triggers Option (SQL Server Management Studio)
How to: Configure the priority boost Option (SQL Server Management Studio)
How to: Set the Recovery Interval (SQL Server Management Studio)
How to: Set Remote Server Access (SQL Server Management Studio)
How to: Set Remote Login Timeout (SQL Server Management Studio)
How to: Configure the scan for startup procs Option (SQL Server Management Studio)
How to: Enforce Distributed Transactions for Remote Procedures (SQL Server Management Studio)
How to: Set a Time Limit for Remote Queries (SQL Server Management Studio)
How to: Configure the two-digit year cutoff Option (SQL Server Management Studio)
How to: Set User Connections (SQL Server Management Studio)
How to: Configure User Options (SQL Server Management Studio)
How to: Configure Packet Size (SQL Server Management Studio)
How to: Configure the query governor cost limit Option (SQL Server Management Studio)
How to: Configure the query wait Option (SQL Server Management Studio)
How to: Enable the Lock Pages in Memory Option (Windows)
How to: Map TCP/IP Ports to NUMA Nodes
How to: Configure SQL Server to Use Soft-NUMA
Expand Minimize
This topic has not yet been rated - Rate this topic

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

SQL Server 2005

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.

ms186947.note(en-US,SQL.90).gifNote:
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.

Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft
|
Site Feedback
© 2013 Microsoft. All rights reserved.