Export (0) Print
Expand All

IServerInformation Properties

The IServerInformation type exposes the following members.

  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 the collation information for the instance of SQL Server.
Public property CollationID Gets the collation identifier for the instance of SQL Server.
Public property ComparisonStyle Gets the comparison style for the instance of SQL Server.
Public property ComputerNamePhysicalNetBIOS Gets the host computer physical NetBIOS name.
Public property Edition Gets 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 value that indicates whether the server uses case-sensitive.
Public property IsClustered Gets a value that indicates whether the instance of SQL Server is clustered.
Public property IsFullTextInstalled Gets a value that indicates whether the Full-Text is installed on the instance of SQL Server.
Public property IsHadrEnabled Gets a value that indicates whether the Hadr is enabled.
Public property IsSingleUser Gets a value that indicates whether the instance of SQL Server is read-only.
Public property IsXTPSupported Gets whether XTP is supported with this interface.
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 of the SQL Server resource in string format.
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 the 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

Community Additions

ADD
Show:
© 2014 Microsoft