Domain/Workgroup Name
|
This field returns the domain or the workgroup name of the
computer that hosts the SQL Server.
|
String
|
Single valued
|
Primary
|
Server Name (Instance)
|
This field returns the name of the SQL Server instance, not the
name of the host.
|
String
|
Single valued
|
Primary
|
Host Name (Node)
|
This field returns the name of the Windows NT server that hosts
the instance of SQL Server.
|
String
|
Single valued
|
Primary
|
Database Name
|
This field returns the name of the database.
|
String
|
Single valued
|
Primary
|
Major Version
|
This field returns the major version of the SQL Server
instance.
|
Integer
|
Single valued
|
Mandatory
|
Operating system
|
This field returns the underlying Operating System.
|
String
|
Single valued
|
Optional
|
Product Version
|
This field returns the SQL Server Product Version.
|
String
|
Single valued
|
Optional
|
Product Level
|
This field returns the SQL Server product level. Possible values
include 'B1', and 'RTM'. This field is only valid for SQL Server
2000 and above.
|
String
|
Single valued
|
Optional
|
Platform
|
Displays the platform ....
|
String
|
Single valued
|
Optional
|
Login Mode
|
The default logon mode for the server. Valid values are
Integrated, Mixed, Normal, and Unknown.
|
String
|
Single valued
|
Optional
|
Version String
|
The complete version of the SQL Server instance.
|
String
|
Single valued
|
Optional
|
Minor Version
|
The minor version of the SQL Server instance.
|
Integer
|
Single valued
|
Optional
|