IServerInformation Interface
An interface based on the Information type properties.
This API is not CLS-compliant.
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
[TypeConverterAttribute(typeof(LocalizableTypeConverter))] [LocalizedPropertyResourcesAttribute("Microsoft.SqlServer.Management.Smo.LocalizableResources")] [DisplayNameKeyAttribute("IServerInformation_Name")] [DisplayDescriptionKeyAttribute("IServerInformation_Desc")] [EvaluationModeAttribute(AutomatedPolicyEvaluationMode.CheckOnSchedule)] [CLSCompliantAttribute(false)] [RootFacetAttribute(typeof(Server))] public interface IServerInformation : IDmfFacet
| Name | Description | |
|---|---|---|
 | BuildClrVersionString | Gets the CLR build version string for the instance of SQL Server. |
| BuildNumber | Gets the build number for the instance of SQL Server. |
| Collation | Gets the collation information for the instance of SQL Server. |
| CollationID | Gets the collation identifier for the instance of SQL Server. |
| ComparisonStyle | Gets the comparison style for the instance of SQL Server. |
| ComputerNamePhysicalNetBIOS | Gets the host computer physical NetBIOS name. |
| Edition | Gets the edition of the instance of SQL Server. |
| EngineEdition | Gets the SQL Server Engine edition as an edition object. |
| ErrorLogPath | Gets the error log path for the instance of SQL Server. |
| IsCaseSensitive | Gets a value that indicates whether the server uses case-sensitive. |
| IsClustered | Gets a value that indicates whether the instance of SQL Server is clustered. |
| IsFullTextInstalled | Gets a value that indicates whether the Full-Text is installed on the instance of SQL Server. |
| IsHadrEnabled | Gets a value that indicates whether the Hadr is enabled. |
| IsPolyBaseInstalled | Gets a value that indicates whether the polybase is installed. |
| IsSingleUser | Gets a value that indicates whether the instance of SQL Server is read-only. |
| IsXTPSupported | Gets whether XTP is supported with this interface. |
| Language | Gets the SQL Server language. |
| MasterDBLogPath | Gets the master database log path for the instance of SQL Server. |
| MasterDBPath | Gets the master database data path for the instance of SQL Server. |
| MaxPrecision | Gets the greatest decimal precision available for exact numeric data types (not floating point), including decimal and numeric. |
| NetName | Gets the network name for an instance of SQL Server. |
| OSVersion | Gets the host computer operating system version. |
| PhysicalMemory | Gets the total RAM installed, in MB, for the computer that is running the instance of SQL Server. |
| Platform | Gets the hardware platform for the computer that is running the instance of SQL Server. |
| Processors | Gets the number of processors that are installed on the computer that is running the instance of SQL Server. |
| Product | Gets the product title for the instance of SQL Server. |
| ProductLevel | Gets the product level for the instance of SQL Server. |
| ResourceLastUpdateDateTime | Gets a DateTime object that specifies the last time the resource database was updated. |
| ResourceVersionString | Gets the version of the SQL Server resource in string format. |
| RootDirectory | Gets the root directory for the instance of SQL Server. |
| SqlCharSet | Gets the SQL character set ID from the collation ID as a tinyint. |
| SqlCharSetName | Gets the SQL character set name from the collation. |
| SqlSortOrder | Gets the SQL sort order ID from the collation. |
| SqlSortOrderName | Gets the SQL sort order name from the collation. |
| VersionMajor | Gets the portion of a component version identifier to the left of the first decimal point in the identifier. |
| VersionMinor | Gets the portion of a component version identifier to the right of the first decimal point in the identifier. |
| VersionString | Gets the date, version, and processor type of the instance of SQL Server. |
This namespace, class, or member is supported only in version 2.0 of the Microsoft .NET Framework.