Export (0) Print
Expand All

Server Properties

 

Applies To: SQL Server 2016 Preview

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

NameDescription
System_CAPS_pubpropertyActiveDirectory

Obsolete.Gets information about the Active Directory settings for the instance of SQL Server.

System_CAPS_pubpropertyAffinityInfo

Gets the AffinityInfo object that is associated with an instance of SQL Server.

System_CAPS_pubpropertyAuditLevel

Gets or sets the AuditLevel property value.

System_CAPS_pubpropertyAudits

Represents a collection of Audit objects. Each Audit object represents an audit log defined on the instance of SQL Server.

System_CAPS_pubpropertyAvailabilityGroups

Gets the available groups in the server.

System_CAPS_pubpropertyBackupDevices

Represents a collection of BackupDevice objects. Each BackupDevice object represents a backup device defined on the instance of SQL Server.

System_CAPS_pubpropertyBackupDirectory

Gets or sets the BackupDirectory property value.

System_CAPS_pubpropertyBrowserServiceAccount

Gets the service account that the Browser service runs under on the instance of SQL Server.

System_CAPS_pubpropertyBrowserStartMode

Gets the start mode for the SQL Server Browser Service running on the instance of SQL Server.

System_CAPS_pubpropertyBuildClrVersion

Gets the BuildClrVersion property value.

System_CAPS_pubpropertyBuildClrVersionString

Gets the version string of the CLR that was used while building the instance.

System_CAPS_pubpropertyBuildNumber

Gets the BuildNumber property value.

System_CAPS_pubpropertyClusterName

Gets the name of the cluster.

System_CAPS_pubpropertyClusterQuorumState

Gets the state of the cluster quorum.

System_CAPS_pubpropertyClusterQuorumType

Gets the type of the cluster quorum.

System_CAPS_pubpropertyCollation

Gets the Collation property value.

System_CAPS_pubpropertyCollationID

Gets the CollationID property value.

System_CAPS_pubpropertyComparisonStyle

Gets the Windows comparison style of the collation.

System_CAPS_pubpropertyComputerNamePhysicalNetBIOS

Gets the NetBIOS name of the local computer on which the instance of SQL Server is currently running.

System_CAPS_pubpropertyConfiguration

Gets the configuration options for the instance of SQL Server.

System_CAPS_pubpropertyConnectionContext

Gets the current server connection details for the instance of SQL Server.

System_CAPS_pubpropertyCredentials

Represents a collection of Credential objects. Each Credential object represents a credential defined on the instance of SQL Server.

System_CAPS_pubpropertyCryptographicProviders

Gets the list of server cryptographic providers.

System_CAPS_pubpropertyDatabases

Represents a collection of Database objects. Each Database object represents a database defined on the instance of SQL Server.

System_CAPS_pubpropertyDefaultFile

Gets or sets the DefaultFile property value.

System_CAPS_pubpropertyDefaultLog

Gets or sets the default log of the server.

System_CAPS_pubpropertyDefaultTextMode

Gets or sets the Boolean property value that specifies whether the default text mode is set for the instance of SQL Server.

System_CAPS_pubpropertyEdition

Gets the Edition property value.

System_CAPS_pubpropertyEndpoints

Represents a collection of Endpoint objects. Each Endpoint object represents an endpoint defined on the instance of SQL Server.

System_CAPS_pubpropertyEngineEdition

Gets the edition of the engine.

System_CAPS_pubpropertyErrorLogPath

Gets the ErrorLogPath property value.

System_CAPS_pubpropertyEvents

Gets the server events that are associated with the instance of SQL Server.

System_CAPS_pubpropertyFilestreamLevel

Gets the level of FILESTREAM access specified on the instance of SQL Server.

System_CAPS_pubpropertyFilestreamShareName

Gets the Windows share name where FILESTREAM data is stored on the instance of SQL Server.

System_CAPS_pubpropertyFullTextService

Gets the Microsoft Search Full-Text service implementation for the instance of SQL Server.

System_CAPS_pubpropertyHadrManagerStatus

Gets the status of the Hadr manager.

System_CAPS_pubpropertyInformation

Gets information about the instance of SQL Server.

System_CAPS_pubpropertyInstallDataDirectory

Gets the local Windows directory where the installation data is stored for the instance of SQL Server.

System_CAPS_pubpropertyInstallSharedDirectory

Gets the remote shared directory where the installation data is stored for the instance of SQL Server.

System_CAPS_pubpropertyInstanceName

Gets the instance name of the instance of SQL Server.

System_CAPS_pubpropertyInstances

Gets the DatabaseEngineInstanceCollection which contains each DatabaseEngineInstance which runs on this server.

System_CAPS_pubpropertyIsCaseSensitive

Gets the value that indicates whether the case is sensitive.

System_CAPS_pubpropertyIsClustered

Gets a value that indicating whether the server is clustered.

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 property value whether the user is single.

System_CAPS_pubpropertyIsXTPSupported

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

System_CAPS_pubpropertyJobServer

Gets the SQL Server Agent associated with the instance of SQL Server.

System_CAPS_pubpropertyLanguage

Gets the language of the server.

System_CAPS_pubpropertyLanguages

Represents a collection of Language objects. Each Language object represents an languages supported by the instance of SQL Server.

System_CAPS_pubpropertyLinkedServers

Represents a collection of LinkedServer objects. Each LinkedServer object represents a linked server registered on the instance of SQL Server.

System_CAPS_pubpropertyLoginMode

Gets or sets the ServerLoginMode property value.

System_CAPS_pubpropertyLogins

Represents a collection of Login objects. Each Login object represents a login defined on the instance of SQL Server.

System_CAPS_pubpropertyMail

Gets the Microsoft SQL Mail service associated with the instance of SQL Server.

System_CAPS_pubpropertyMailProfile

Gets or sets the mail profile of the server.

System_CAPS_pubpropertyMasterDBLogPath

Get the MasterDBLogPath property value.

System_CAPS_pubpropertyMasterDBPath

Gets the MasterDBPath property value.

System_CAPS_pubpropertyMaxPrecision

Gets the MaxPrecision property value.

System_CAPS_pubpropertyName

Gets the name of the server, which is the physical machine name.

System_CAPS_pubpropertyNamedPipesEnabled

Gets the Boolean value that specifies whether Named Pipes provider is enabled for client-server connectivity on the instance of SQL Server.

System_CAPS_pubpropertyNetName

Gets the NetName property value.

System_CAPS_pubpropertyNumberOfLogFiles

Gets or sets the NumberOfLogFiles property value.

System_CAPS_pubpropertyOleDbProviderSettings

Gets the DbProviderSettings property value.

System_CAPS_pubpropertyOSVersion

Gets the OSVersion property value.

System_CAPS_pubpropertyPerfMonMode

Gets or sets the PerfMonMode property value.

System_CAPS_pubpropertyPhysicalMemory

Gets the physical memory used by the server.

System_CAPS_pubpropertyPhysicalMemoryUsageInKB

Gets an Int64 value that specifies the amount of memory in use by the instance of the Database Engine, in kilobytes.

System_CAPS_pubpropertyPlatform

Gets the server platform.

System_CAPS_pubpropertyProcessors

Gets the Processors property value.

System_CAPS_pubpropertyProcessorUsage

Gets an Int32 value that specifies the processor time used by the instance of the Database Engine.

System_CAPS_pubpropertyProduct

Gets the product of the server.

System_CAPS_pubpropertyProductLevel

Gets the ProductLevel property value.

System_CAPS_pubpropertyProperties

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

System_CAPS_pubpropertyProxyAccount

Gets the proxy account associated with the instance of SQL Server.

System_CAPS_pubpropertyResourceGovernor

Gets the resource governor of the server.

System_CAPS_pubpropertyResourceLastUpdateDateTime

Gets the last time the resource was last updated.

System_CAPS_pubpropertyResourceVersion

Gets the ResourceVersion property.

System_CAPS_pubpropertyResourceVersionString

Gets the ResouceVersionString property value.

System_CAPS_pubpropertyRoles

Represents a collection of ServerRole objects. Each ServerRole object represents a role defined on the instance of SQL Server.

System_CAPS_pubpropertyRootDirectory

Gets the RootDirectory property value.

System_CAPS_pubpropertyServerAuditSpecifications

Represents a collection of ServerAuditSpecification objects. Each ServerAuditSpecification object represents a specific audit specification defined on the instance of SQL Server.

System_CAPS_pubpropertyServerType

Gets the server type for the instance of SQL Server.

System_CAPS_pubpropertyServiceAccount

Gets the service account under which the instance of SQL Server is running.

System_CAPS_pubpropertyServiceInstanceId

Gets the ID value that uniquely identifies the service instance for this instance of SQL Server.

System_CAPS_pubpropertyServiceMasterKey

Gets the service master key associated with the instance of SQL Server.

System_CAPS_pubpropertyServiceName

Gets the service name for the server.

System_CAPS_pubpropertyServiceStartMode

Gets the start mode for the SQL Server service.

System_CAPS_pubpropertySettings

Gets modifiable settings for the instance of SQL Server.

System_CAPS_pubpropertySmartAdmin

Gets the smart admin associated with this server.

System_CAPS_pubpropertySqlCharSet

Gets the value that identifies the character set used by the server.

System_CAPS_pubpropertySqlCharSetName

Gets the name of the character set used by the server.

System_CAPS_pubpropertySqlDomainGroup

Gets the domain group for the instance of SQL Server.

System_CAPS_pubpropertySqlSortOrder

Gets the SQL sort order from the collation.

System_CAPS_pubpropertySqlSortOrderName

Gets the name of the sort order used by the server.

System_CAPS_pubpropertyState

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

System_CAPS_pubpropertyStatus

Gets the current status of the Server.

System_CAPS_pubpropertySystemDataTypes

Represents a collection of SystemDataType objects. Each SystemDataType object represents a system data type defined on the instance of SQL Server.

System_CAPS_pubpropertySystemMessages

Represents a collection of SystemMessage objects. Each SystemMessage object represents a system message defined on the instance of SQL Server.

System_CAPS_pubpropertyTapeLoadWaitTime

Gets or sets the TapeLoadWaitTime property value.

System_CAPS_pubpropertyTcpEnabled

Gets the Boolean value that determines whether TCP/IP protocol is enabled on this instance of SQL Server.

System_CAPS_pubpropertyTriggers

Represents a collection of ServerDdlTrigger objects. Each ServerDdlTrigger object represents a server data definition language (DDL) trigger that is defined on the instance of SQL Server.

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_pubpropertyUserDefinedMessages

Represents a collection of UserDefinedMessage objects. Each UserDefinedMessage object represents a user-defined message defined on the instance of SQL Server.

System_CAPS_pubpropertyUserOptions

Gets the user options for the current connection to the instance of SQL Server.

System_CAPS_pubpropertyVersion

Gets the Version property value.

System_CAPS_pubpropertyVersionMajor

Gets the major version of the server.

System_CAPS_pubpropertyVersionMinor

Gets the VersionMinor property value.

System_CAPS_pubpropertyVersionString

Gets the version string of the server.

Return to top
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2015 Microsoft