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

ServerAdapter Class

 

Applies To: SQL Server 2016 Preview

This class aggregates otherwise hidden server properties.

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

System.Object
  Microsoft.SqlServer.Management.Smo.ServerAdapterBase
    Microsoft.SqlServer.Management.Smo.ServerAdapter

public class ServerAdapter : ServerAdapterBase, IDmfAdapter, 
	IServerAuditFacet, IDmfFacet

NameDescription
System_CAPS_pubmethodServerAdapter(Server)

Initializes a new instance of the ServerAdapter class.

NameDescription
System_CAPS_pubpropertyAdHocRemoteQueriesEnabled

Gets or sets the value of the referenced property.(Inherited from ServerAdapterBase.)

System_CAPS_pubpropertyAffinity64IOMask

Gets or sets the value of the referenced property.(Inherited from ServerAdapterBase.)

System_CAPS_pubpropertyAffinity64Mask

Gets or sets the value of the referenced property.(Inherited from ServerAdapterBase.)

System_CAPS_pubpropertyAffinityIOMask

Gets or sets the value of the referenced property.(Inherited from ServerAdapterBase.)

System_CAPS_pubpropertyAffinityMask

Gets or sets the value of the referenced property.(Inherited from ServerAdapterBase.)

System_CAPS_pubpropertyAgentXPsEnabled

Gets or sets the Boolean value that determines whether the referenced property is enabled.(Inherited from ServerAdapterBase.)

System_CAPS_pubpropertyAllowUpdates

Gets or sets the Boolean value that determines whether the referenced property is enabled.(Inherited from ServerAdapterBase.)

System_CAPS_pubpropertyAweEnabled

Gets or sets the Boolean value that determines whether the referenced property is enabled.(Inherited from ServerAdapterBase.)

System_CAPS_pubpropertyBackupDirectory

Gets or sets the value of the referenced property.(Inherited from ServerAdapterBase.)

System_CAPS_pubpropertyBlockedProcessThreshold

Gets or sets the value of the referenced property.(Inherited from ServerAdapterBase.)

System_CAPS_pubpropertyBrowserServiceAccount

Gets or sets the value of the referenced property.(Inherited from ServerAdapterBase.)

System_CAPS_pubpropertyBrowserStartMode

Gets or sets the value of the referenced property.(Inherited from ServerAdapterBase.)

System_CAPS_pubpropertyC2AuditTracingEnabled

Gets or sets the Boolean value that determines whether the referenced property is enabled.(Inherited from ServerAdapterBase.)

System_CAPS_pubpropertyClrIntegrationEnabled

Gets or sets the Boolean value that determines whether the referenced property is enabled.(Inherited from ServerAdapterBase.)

System_CAPS_pubpropertyCollation

Gets or sets the value of the referenced property.(Inherited from ServerAdapterBase.)

System_CAPS_pubpropertyCommonCriteriaComplianceEnabled

Gets or sets the Boolean value that determines whether the referenced property is enabled.(Inherited from ServerAdapterBase.)

System_CAPS_pubpropertyContainmentEnabled

Enables or disables contained databases and authentication using Facets across a server instance.(Inherited from ServerAdapterBase.)

System_CAPS_pubpropertyCostThresholdForParallelism

Gets or sets the value of the referenced property.(Inherited from ServerAdapterBase.)

System_CAPS_pubpropertyCrossDBOwnershipChainingEnabled

Gets or sets the Boolean value that determines whether the referenced property is enabled.(Inherited from ServerAdapterBase.)

System_CAPS_pubpropertyCursorThreshold

Gets or sets the Int32 value that determines the value of the referenced property.(Inherited from ServerAdapterBase.)

System_CAPS_pubpropertyDatabaseMailEnabled

Gets or sets the Boolean value that determines whether the referenced property is enabled.(Inherited from ServerAdapterBase.)

System_CAPS_pubpropertyDefaultBackupCompressionEnabled

Gets or sets the Boolean value that determines whether the referenced property is enabled.(Inherited from ServerAdapterBase.)

System_CAPS_pubpropertyDefaultFile

Gets or sets the value of the referenced property.(Inherited from ServerAdapterBase.)

System_CAPS_pubpropertyDefaultFullTextLanguage

Gets or sets the value of the referenced property.(Inherited from ServerAdapterBase.)

System_CAPS_pubpropertyDefaultLanguage

Gets or sets the value of the referenced property.(Inherited from ServerAdapterBase.)

System_CAPS_pubpropertyDefaultLog

Gets or sets the value of the referenced property.(Inherited from ServerAdapterBase.)

System_CAPS_pubpropertyDefaultTraceEnabled

Gets or sets the Boolean value that determines whether the referenced property is enabled.(Inherited from ServerAdapterBase.)

System_CAPS_pubpropertyDisallowResultsFromTriggers

Gets or sets a value that specifies whether SQL Server triggers can generate results.(Inherited from ServerAdapterBase.)

System_CAPS_pubpropertyDynamicLocks

Gets or sets the value of the referenced property.(Inherited from ServerAdapterBase.)

System_CAPS_pubpropertyExtensibleKeyManagementEnabled

Gets or sets the Boolean value that determines whether the referenced property is enabled.(Inherited from ServerAdapterBase.)

System_CAPS_pubpropertyFilestreamAccessLevel

Gets or sets the value of the referenced property.(Inherited from ServerAdapterBase.)

System_CAPS_pubpropertyFilestreamLevel

Gets or sets the value of the referenced property.(Inherited from ServerAdapterBase.)

System_CAPS_pubpropertyFilestreamShareName

Gets or sets the value of the referenced property.(Inherited from ServerAdapterBase.)

System_CAPS_pubpropertyFillFactor

Gets or sets the value of the referenced property.(Inherited from ServerAdapterBase.)

System_CAPS_pubpropertyFullTextCrawlBandwidthMax

Gets or sets the value of the referenced property.(Inherited from ServerAdapterBase.)

System_CAPS_pubpropertyFullTextCrawlBandwidthMin

Gets or sets the value of the referenced property.(Inherited from ServerAdapterBase.)

System_CAPS_pubpropertyFullTextCrawlRangeMax

Gets or sets the maximum number of partitions that SQL Server is allowed to use during a full index crawl.(Inherited from ServerAdapterBase.)

System_CAPS_pubpropertyFullTextNotifyBandwidthMax

Gets or sets the value of the referenced property.(Inherited from ServerAdapterBase.)

System_CAPS_pubpropertyFullTextNotifyBandwidthMin

Gets or sets the value of the referenced property.(Inherited from ServerAdapterBase.)

System_CAPS_pubpropertyIndexCreateMemory

Gets or sets the value of the referenced property.(Inherited from ServerAdapterBase.)

System_CAPS_pubpropertyInDoubtTransactionResolution

Gets or sets the value of the referenced property.(Inherited from ServerAdapterBase.)

System_CAPS_pubpropertyInstallDataDirectory

Gets or sets the value of the referenced property.(Inherited from ServerAdapterBase.)

System_CAPS_pubpropertyInstallSharedDirectory

Gets or sets the value of the referenced property.(Inherited from ServerAdapterBase.)

System_CAPS_pubpropertyInstanceName

Gets or sets the value of the referenced property.(Inherited from ServerAdapterBase.)

System_CAPS_pubpropertyLightweightPoolingEnabled

Gets or sets the Boolean value that determines whether the referenced property is enabled.(Inherited from ServerAdapterBase.)

System_CAPS_pubpropertyLoginAuditLevel

Gets or sets the value of the referenced property.(Inherited from ServerAdapterBase.)

System_CAPS_pubpropertyLoginMode

Gets or sets the value of the referenced property.(Inherited from ServerAdapterBase.)

System_CAPS_pubpropertyMaxDegreeOfParallelism

Gets or sets the value of the referenced property.(Inherited from ServerAdapterBase.)

System_CAPS_pubpropertyMaxServerMemory

Gets or sets the value of the referenced property.(Inherited from ServerAdapterBase.)

System_CAPS_pubpropertyMaxWorkerThreads

Gets or sets the value of the referenced property.(Inherited from ServerAdapterBase.)

System_CAPS_pubpropertyMediaRetention

Gets or sets the value of the referenced property.(Inherited from ServerAdapterBase.)

System_CAPS_pubpropertyMinMemoryPerQuery

Gets or sets the value of the referenced property.(Inherited from ServerAdapterBase.)

System_CAPS_pubpropertyMinServerMemory

Gets or sets the value of the referenced property.(Inherited from ServerAdapterBase.)

System_CAPS_pubpropertyNamedPipesEnabled

Gets or sets the Boolean value that determines whether the referenced property is enabled.(Inherited from ServerAdapterBase.)

System_CAPS_pubpropertyNestedTriggersEnabled

Gets or sets the Boolean value that determines whether the referenced property is enabled.(Inherited from ServerAdapterBase.)

System_CAPS_pubpropertyNetworkPacketSize

Gets or sets the value of the referenced property.(Inherited from ServerAdapterBase.)

System_CAPS_pubpropertyOleAutomationEnabled

Gets or sets the Boolean value that determines whether the referenced property is enabled.(Inherited from ServerAdapterBase.)

System_CAPS_pubpropertyOpenObjects

Gets or sets the value of the referenced property.(Inherited from ServerAdapterBase.)

System_CAPS_pubpropertyOptimizeAdhocWorkloads

Gets or sets a value that specifies whether optimization for ad hoc workloads is enabled.(Inherited from ServerAdapterBase.)

System_CAPS_pubpropertyPrecomputeRank

Gets or sets the Boolean value that determines whether the referenced property is enabled.(Inherited from ServerAdapterBase.)

System_CAPS_pubpropertyPriorityBoost

Gets or sets the Boolean value that determines whether the referenced property is enabled.(Inherited from ServerAdapterBase.)

System_CAPS_pubpropertyProtocolHandlerTimeout

Gets or sets the value of the referenced property.(Inherited from ServerAdapterBase.)

System_CAPS_pubpropertyQueryGovernorCostLimit

Gets or sets the value of the referenced property.(Inherited from ServerAdapterBase.)

System_CAPS_pubpropertyQueryWait

Gets or sets the value of the referenced property.(Inherited from ServerAdapterBase.)

System_CAPS_pubpropertyRecoveryInterval

Gets or sets the value of the referenced property.(Inherited from ServerAdapterBase.)

System_CAPS_pubpropertyRemoteAccessEnabled

Gets or sets the Boolean value that determines whether the referenced property is enabled.(Inherited from ServerAdapterBase.)

System_CAPS_pubpropertyRemoteDacEnabled

Gets or sets the Boolean value that determines whether the referenced property is enabled.(Inherited from ServerAdapterBase.)

System_CAPS_pubpropertyRemoteLoginTimeout

Gets or sets the value of the referenced property.(Inherited from ServerAdapterBase.)

System_CAPS_pubpropertyRemoteProcTransEnabled

Gets or sets the Boolean value that determines whether the referenced property is enabled.(Inherited from ServerAdapterBase.)

System_CAPS_pubpropertyRemoteQueryTimeout

Gets or sets the value of the referenced property.(Inherited from ServerAdapterBase.)

System_CAPS_pubpropertyReplicationMaxTextSize

Gets or sets the value of the referenced property.(Inherited from ServerAdapterBase.)

System_CAPS_pubpropertyReplicationXPsEnabled

Gets or sets the Boolean value that determines whether the referenced property is enabled.(Inherited from ServerAdapterBase.)

System_CAPS_pubpropertyScanForStartupProcedures

Gets or sets the Boolean value that determines whether the referenced property is enabled.(Inherited from ServerAdapterBase.)

System_CAPS_protpropertyServer

Gets the Server associated with the ServerAdapterBase.(Inherited from ServerAdapterBase.)

System_CAPS_pubpropertyServerTriggerRecursionEnabled

Gets or sets the Boolean value that determines whether the referenced property is enabled.(Inherited from ServerAdapterBase.)

System_CAPS_pubpropertyServiceName

Gets or sets the value of the referenced property.(Inherited from ServerAdapterBase.)

System_CAPS_pubpropertyServiceStartMode

Gets or sets the value of the referenced property.(Inherited from ServerAdapterBase.)

System_CAPS_pubpropertySetWorkingSetSize

Gets or sets the Boolean value that determines whether the referenced property is enabled.(Inherited from ServerAdapterBase.)

System_CAPS_pubpropertyShowAdvancedOptions

Gets or sets the Boolean value that determines whether the referenced property is enabled.(Inherited from ServerAdapterBase.)

System_CAPS_pubpropertySmoAndDmoXPsEnabled

Gets or sets the Boolean value that determines whether the referenced property is enabled.(Inherited from ServerAdapterBase.)

System_CAPS_pubpropertySqlDomainGroup

Gets or sets the value of the referenced property.(Inherited from ServerAdapterBase.)

System_CAPS_pubpropertySqlMailEnabled

Gets or sets the Boolean value that determines whether the referenced property is enabled.(Inherited from ServerAdapterBase.)

System_CAPS_pubpropertyTcpEnabled

Gets or sets the Boolean value that determines whether the referenced property is enabled.(Inherited from ServerAdapterBase.)

System_CAPS_pubpropertyTransformNoiseWords

Gets or sets the Boolean value that determines whether the referenced property is enabled.(Inherited from ServerAdapterBase.)

System_CAPS_pubpropertyTwoDigitYearCutoff

Gets or sets the value of the referenced property.(Inherited from ServerAdapterBase.)

System_CAPS_pubpropertyUserConnections

Gets or sets the value of the referenced property.(Inherited from ServerAdapterBase.)

System_CAPS_pubpropertyUserInstancesEnabled

Gets or sets the Boolean value that determines whether the referenced property is enabled.(Inherited from ServerAdapterBase.)

System_CAPS_pubpropertyUserInstanceTimeout

Gets or sets the value of the referenced property.(Inherited from ServerAdapterBase.)

System_CAPS_pubpropertyUserOptions

Gets or sets the value of the referenced property.(Inherited from ServerAdapterBase.)

System_CAPS_pubpropertyWebAssistantEnabled

Gets or sets the Boolean value that determines whether the referenced property is enabled.(Inherited from ServerAdapterBase.)

System_CAPS_pubpropertyXPCmdShellEnabled

Gets or sets the Boolean value that determines whether the referenced property is enabled.(Inherited from ServerAdapterBase.)

NameDescription
System_CAPS_pubmethodAlter()

Updates any object property changes on the instance of SQL Server.(Inherited from ServerAdapterBase.)

System_CAPS_pubmethodEquals(Object)

(Inherited from Object.)

System_CAPS_protmethodFinalize()

(Inherited from Object.)

System_CAPS_pubmethodGetHashCode()

(Inherited from Object.)

System_CAPS_pubmethodGetType()

(Inherited from Object.)

System_CAPS_protmethodMemberwiseClone()

(Inherited from Object.)

System_CAPS_pubmethodRefresh()

Updates the object.(Inherited from ServerAdapterBase.)

System_CAPS_pubmethodToString()

(Inherited from Object.)

This class acts as the flattener for server properties that are hidden in Settings and Configuration. Facets will inherit from this class to add new logical properties, use the Alter and Refresh methods of this class.

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Return to top

Community Additions

Show:
© 2015 Microsoft