Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
MSDN Library

IServerInformation Properties

 

Applies To: SQL Server 2016 Preview

Namespace:   Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

NameDescription
System_CAPS_pubpropertyBuildClrVersionString

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

System_CAPS_pubpropertyBuildNumber

Gets the build number for the instance of SQL Server.

System_CAPS_pubpropertyCollation

Gets the collation information for the instance of SQL Server.

System_CAPS_pubpropertyCollationID

Gets the collation identifier for the instance of SQL Server.

System_CAPS_pubpropertyComparisonStyle

Gets the comparison style for the instance of SQL Server.

System_CAPS_pubpropertyComputerNamePhysicalNetBIOS

Gets the host computer physical NetBIOS name.

System_CAPS_pubpropertyEdition

Gets the edition of the instance of SQL Server.

System_CAPS_pubpropertyEngineEdition

Gets the SQL Server Engine edition as an edition object.

System_CAPS_pubpropertyErrorLogPath

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

System_CAPS_pubpropertyIsCaseSensitive

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

System_CAPS_pubpropertyIsClustered

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

System_CAPS_pubpropertyIsFullTextInstalled

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

System_CAPS_pubpropertyIsHadrEnabled

Gets a value that indicates whether the Hadr is enabled.

System_CAPS_pubpropertyIsSingleUser

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

System_CAPS_pubpropertyIsXTPSupported

Gets whether XTP is supported with this interface.

System_CAPS_pubpropertyLanguage

Gets the SQL Server language.

System_CAPS_pubpropertyMasterDBLogPath

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

System_CAPS_pubpropertyMasterDBPath

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

System_CAPS_pubpropertyMaxPrecision

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

System_CAPS_pubpropertyNetName

Gets the network name for an instance of SQL Server.

System_CAPS_pubpropertyOSVersion

Gets the host computer operating system version.

System_CAPS_pubpropertyPhysicalMemory

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

System_CAPS_pubpropertyPlatform

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

System_CAPS_pubpropertyProcessors

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

System_CAPS_pubpropertyProduct

Gets the product title for the instance of SQL Server.

System_CAPS_pubpropertyProductLevel

Gets the product level for the instance of SQL Server.

System_CAPS_pubpropertyResourceLastUpdateDateTime

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

System_CAPS_pubpropertyResourceVersionString

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

System_CAPS_pubpropertyRootDirectory

Gets the root directory for the instance of SQL Server.

System_CAPS_pubpropertySqlCharSet

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

System_CAPS_pubpropertySqlCharSetName

Gets the SQL character set name from the collation.

System_CAPS_pubpropertySqlSortOrder

Gets the SQL sort order ID from the collation.

System_CAPS_pubpropertySqlSortOrderName

Gets the SQL sort order name from the collation.

System_CAPS_pubpropertyVersionMajor

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

System_CAPS_pubpropertyVersionMinor

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

System_CAPS_pubpropertyVersionString

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

Return to top
Show:
© 2015 Microsoft