• Article

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

Top