IServerInformation Members
Include Protected Members
Include Inherited Members
An interface based on the Information type properties.
The IServerInformation type exposes the following members.
Properties
| Name | Description | |
|---|---|---|
| .gif) | BuildClrVersionString | Gets the CLR build version string for the instance of SQL Server. | 
| .gif) | BuildNumber | Gets the build number for the instance of SQL Server. | 
| .gif) | Collation | Gets collation information for the instance of SQL Server. | 
| .gif) | CollationID | Gets the CollationID for the instance of SQL Server. | 
| .gif) | ComparisonStyle | Gets the Comparision Style.for the instance of SQL Server. | 
| .gif) | ComputerNamePhysicalNetBIOS | Gets the host computer physical NetBIOS name. | 
| .gif) | Edition | Get the edition of the instance of SQL Server. | 
| .gif) | EngineEdition | Gets the SQL Server Engine edition as an edition object. | 
| .gif) | ErrorLogPath | Gets the error log path for the instance of SQL Server. | 
| .gif) | IsCaseSensitive | Gets a Boolean value that specifies case sensitivity. | 
| .gif) | IsClustered | Gets a Boolean value that specifies if the instance of SQL Server is clustered. | 
| .gif) | IsFullTextInstalled | Gets a Boolean value that specifies if Full-Text is installed on the instance of SQL Server. | 
| .gif) | IsSingleUser | Gets a Boolean value that specifies if the instance of SQL Server is read-only. | 
| .gif) | Language | Gets the SQL Server language. | 
| .gif) | MasterDBLogPath | Gets the master database log path for the instance of SQL Server. | 
| .gif) | MasterDBPath | Gets the master database data path for the instance of SQL Server. | 
| .gif) | MaxPrecision | Gets the greatest decimal precision available for exact numeric data types (not floating point), including decimal and numeric. | 
| .gif) | NetName | Gets the network name for an instance of SQL Server. | 
| .gif) | OSVersion | Gets the host computer operating system version. | 
| .gif) | PhysicalMemory | Gets the total RAM installed, in MB, for the computer that is running the instance of SQL Server. | 
| .gif) | Platform | Gets the hardware platform for the computer that is running the instance of SQL Server. | 
| .gif) | Processors | Gets the number of processors that are installed on the computer that is running the instance of SQL Server. | 
| .gif) | Product | Gets the product title for the instance of SQL Server. | 
| .gif) | ProductLevel | Gets the product level for the instance of SQL Server. | 
| .gif) | ResourceLastUpdateDateTime | Gets a DateTime object that specifies the last time the resource database was updated. | 
| .gif) | ResourceVersionString | Gets the version number of the resource database. | 
| .gif) | RootDirectory | Gets the root directory for the instance of SQL Server. | 
| .gif) | SqlCharSet | Gets the SQL character set ID from the collation ID as a tinyint. | 
| .gif) | SqlCharSetName | Gets the SQL character set name from the collation. | 
| .gif) | SqlSortOrder | Gets the SQL sort order ID from the collation. | 
| .gif) | SqlSortOrderName | Gets SQL sort order name from the collation. | 
| .gif) | VersionMajor | Gets the portion of a component version identifier to the left of the first decimal point in the identifier. | 
| .gif) | VersionMinor | Gets the portion of a component version identifier to the right of the first decimal point in the identifier. | 
| .gif) | VersionString | Gets the date, version, and processor type of the instance of SQL Server. | 
Top