Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

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