IServerInformation IServerInformation IServerInformation Interface

Definition

Important

This API is not CLS-compliant.

An interface based on the Information type properties.

public interface class IServerInformation : Microsoft::SqlServer::Management::Sdk::Sfc::IDmfFacet
[Microsoft.SqlServer.Management.Facets.EvaluationMode(Microsoft.SqlServer.Management.Dmf.AutomatedPolicyEvaluationMode.CheckOnSchedule)]
[Microsoft.SqlServer.Management.Sdk.Sfc.DisplayDescriptionKey("IServerInformation_Desc")]
[Microsoft.SqlServer.Management.Sdk.Sfc.DisplayNameKey("IServerInformation_Name")]
[Microsoft.SqlServer.Management.Sdk.Sfc.LocalizedPropertyResources("Microsoft.SqlServer.Management.Smo.LocalizableResources")]
[Microsoft.SqlServer.Management.Sdk.Sfc.RootFacet(typeof(Microsoft.SqlServer.Management.Smo.Server))]
[System.CLSCompliant(false)]
[System.ComponentModel.TypeConverter(typeof(Microsoft.SqlServer.Management.Sdk.Sfc.LocalizableTypeConverter))]
public interface IServerInformation : Microsoft.SqlServer.Management.Sdk.Sfc.IDmfFacet
Public Interface IServerInformation
Implements IDmfFacet
Derived
Attributes
Implements

Remarks

This namespace, class, or member is supported only in version 2.0 of the Microsoft .NET Framework.

Properties

BuildClrVersionString BuildClrVersionString BuildClrVersionString

Gets the CLR build version string for the instance of SQL Server.

BuildNumber BuildNumber BuildNumber

Gets the build number for the instance of SQL Server.

Collation Collation Collation

Gets the collation information for the instance of SQL Server.

CollationID CollationID CollationID

Gets the collation identifier for the instance of SQL Server.

ComparisonStyle ComparisonStyle ComparisonStyle

Gets the comparison style for the instance of SQL Server.

ComputerNamePhysicalNetBIOS ComputerNamePhysicalNetBIOS ComputerNamePhysicalNetBIOS

Gets the host computer physical NetBIOS name.

Edition Edition Edition

Gets the edition of the instance of SQL Server.

EngineEdition EngineEdition EngineEdition

Gets the SQL Server Engine edition as an edition object.

ErrorLogPath ErrorLogPath ErrorLogPath

Gets the error log path for the instance of SQL Server.

IsCaseSensitive IsCaseSensitive IsCaseSensitive

Gets a value that indicates whether the server uses case-sensitive.

IsClustered IsClustered IsClustered

Gets a value that indicates whether the instance of SQL Server is clustered.

IsFullTextInstalled IsFullTextInstalled IsFullTextInstalled

Gets a value that indicates whether the Full-Text is installed on the instance of SQL Server.

IsHadrEnabled IsHadrEnabled IsHadrEnabled

Gets a value that indicates whether the Hadr is enabled.

IsPolyBaseInstalled IsPolyBaseInstalled IsPolyBaseInstalled

Gets a value that indicates whether the polybase is installed.

IsSingleUser IsSingleUser IsSingleUser

Gets a value that indicates whether the instance of SQL Server is read-only.

IsXTPSupported IsXTPSupported IsXTPSupported

Gets whether XTP is supported with this interface.

Language Language Language

Gets the SQL Server language.

MasterDBLogPath MasterDBLogPath MasterDBLogPath

Gets the master database log path for the instance of SQL Server.

MasterDBPath MasterDBPath MasterDBPath

Gets the master database data path for the instance of SQL Server.

MaxPrecision MaxPrecision MaxPrecision

Gets the greatest decimal precision available for exact numeric data types (not floating point), including decimal and numeric.

NetName NetName NetName

Gets the network name for an instance of SQL Server.

OSVersion OSVersion OSVersion

Gets the host computer operating system version.

PhysicalMemory PhysicalMemory PhysicalMemory

Gets the total RAM installed, in MB, for the computer that is running the instance of SQL Server.

Platform Platform Platform

Gets the hardware platform for the computer that is running the instance of SQL Server.

Processors Processors Processors

Gets the number of processors that are installed on the computer that is running the instance of SQL Server.

Product Product Product

Gets the product title for the instance of SQL Server.

ProductLevel ProductLevel ProductLevel

Gets the product level for the instance of SQL Server.

ResourceLastUpdateDateTime ResourceLastUpdateDateTime ResourceLastUpdateDateTime

Gets a DateTime object that specifies the last time the resource database was updated.

ResourceVersionString ResourceVersionString ResourceVersionString

Gets the version of the SQL Server resource in string format.

RootDirectory RootDirectory RootDirectory

Gets the root directory for the instance of SQL Server.

SqlCharSet SqlCharSet SqlCharSet

Gets the SQL character set ID from the collation ID as a tinyint.

SqlCharSetName SqlCharSetName SqlCharSetName

Gets the SQL character set name from the collation.

SqlSortOrder SqlSortOrder SqlSortOrder

Gets the SQL sort order ID from the collation.

SqlSortOrderName SqlSortOrderName SqlSortOrderName

Gets the SQL sort order name from the collation.

VersionMajor VersionMajor VersionMajor

Gets the portion of a component version identifier to the left of the first decimal point in the identifier.

VersionMinor VersionMinor VersionMinor

Gets the portion of a component version identifier to the right of the first decimal point in the identifier.

VersionString VersionString VersionString

Gets the date, version, and processor type of the instance of SQL Server.

Applies to