Information Properties

Information Properties

 

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

NameDescription
System_CAPS_pubpropertyBuildClrVersion

Gets a version object that identifies the common language runtime that is running in the server.

System_CAPS_pubpropertyBuildClrVersionString

A string that identifies the build number of the common language runtime that is running in the server.

System_CAPS_pubpropertyBuildNumber

Gets the build number for the instance of SQL Server.

System_CAPS_pubpropertyCollation

Gets the default collation for the instance of SQL Server.

System_CAPS_pubpropertyCollationID

Gets the collation ID for the instance of SQL Server.

System_CAPS_pubpropertyComparisonStyle

Gets the comparison style for the instance of SQL Server.

System_CAPS_pubpropertyComputerNamePhysicalNetBIOS

Gets the computer name stored in the net BIOS.

System_CAPS_pubpropertyEdition

Gets the edition of the instance of SQL Server.

System_CAPS_pubpropertyEngineEdition

Gets the edition of the engine for the instance of SQL Server.

System_CAPS_pubpropertyErrorLogPath

Gets the file directory where the error log is stored on the instance of SQL Server.

System_CAPS_pubpropertyFullyQualifiedNetName

Gets the fully qualified NetBIOS name of the network on which the instance of SQL Server is running.

System_CAPS_pubpropertyIsCaseSensitive

Gets the Boolean value that specifies whether the instance of SQL Server is case-sensitive.

System_CAPS_pubpropertyIsClustered

Gets the Boolean value that specifies whether the instance of SQL Server is a clustered server.

System_CAPS_pubpropertyIsFullTextInstalled

Gets the Boolean value that specifies whether full-text service 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 the Boolean value that specifies whether the instance of SQL Server is read-only.

System_CAPS_pubpropertyIsXTPSupported

Gets the Boolean value that specifies whether the instance of SQL Server supports Extreme Transaction Processing (XTP).

System_CAPS_pubpropertyLanguage

Gets the default language used by the instance of SQL Server.

System_CAPS_pubpropertyMasterDBLogPath

Gets the log file directory for the master database on the instance of SQL Server.

System_CAPS_pubpropertyMasterDBPath

Gets the database file directory for the master database on 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 NetBIOS name of the network on which the instance of SQL Server is running.

System_CAPS_pubpropertyOSVersion

Gets the operating system version of the computer running the instance of SQL Server.

System_CAPS_pubpropertyParent

Gets the Server object that is the parent object of the Information object.

System_CAPS_pubpropertyPhysicalMemory

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

System_CAPS_pubpropertyPlatform

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

System_CAPS_pubpropertyProcessors

Gets the number of processors installed on the computer 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_pubpropertyProperties

Gets a collection of Property objects that represent the object properties.(Inherited from SqlSmoObject.)

System_CAPS_pubpropertyResourceLastUpdateDateTime

Gets the date and time when the SQL Server resource was last updated.

System_CAPS_pubpropertyResourceVersion

Gets the version of the SQL Server resource.

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 Int16 value that identifies the character set used by the instance of SQL Server.

System_CAPS_pubpropertySqlCharSetName

Gets the name of the character set used by the instance of SQL Server.

System_CAPS_pubpropertySqlSortOrder

Gets the Int16 value that identifies the sort order used by the instance of SQL Server.

System_CAPS_pubpropertySqlSortOrderName

Gets the name of the sort order used by the instance of SQL Server.

System_CAPS_pubpropertyState

Gets the state of the referenced object.(Inherited from SmoObjectBase.)

System_CAPS_pubpropertyUrn

Gets the Uniform Resource Name (URN) address value that uniquely identifies the object.(Inherited from SqlSmoObject.)

System_CAPS_pubpropertyUserData

Gets or sets user-defined data associated with the referenced object.(Inherited from SmoObjectBase.)

System_CAPS_pubpropertyVersion

Gets the version of the instance of SQL Server.

System_CAPS_pubpropertyVersionMajor

Gets the major version number of the instance of SQL Server.

System_CAPS_pubpropertyVersionMinor

Gets the minor version of the instance of SQL Server.

System_CAPS_pubpropertyVersionString

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

Return to top
Show:
© 2016 Microsoft