Building SQL Server Inventory - Professional SQL Server 2008 Administration with Windows PowerShell - page 355

Servers
The Servers table contains information about all the SQL Server instances. The schema of the Servers
table is shown in Table 15-4.

Table 15-4: Servers Table Schema

Column DataType Description

serverID int identity(1000,1) ID of the SQL Server

instanceName varchar(128) MSSQLSERVER for the default instance. For a named

instance, instanceName

= serverName.

int Contains the ID of the standalone host of the SQL Server.

Null if the server is on a cluster.

hosted

int Contains the ID of the cluster hosting this server. Null if

the server is on a standalone host.

clustered

Status char(1) Status of this server. Possible values include D

(Development), Q (Quality Assurance), P (Production),
U (User Acceptance Testing), and R (Disaster Recovery).

tcpPort varchar(10) TCP port on which the SQL Server is listening

varchar(128) Network protocols used by the SQL server

serverNetwork
Protocols

varchar(10) 2008, 2005, or 2000

Type

Edition varchar(128) Enterprise, Standard, or Developer

Version varchar(20) 10.0.1300

varchar(10) Service pack installed on the SQL Server

servicePack

startupParameters varchar(512) Parameters used at SQL Server startup

systemDbDevice varchar(512) Path to the directory that contains system databases

varchar(512) Path to the SQL Server ErrorLog

errorLogLocation

varchar(128) Collation of the SQL Server

Collation

minMemory bigint Minimum memory configured for the SQL Server

Continued