ServerAdapter Class
SQL Server 2012
This class aggregates otherwise hidden server properties.
System.Object
Microsoft.SqlServer.Management.Smo.ServerAdapterBase
Microsoft.SqlServer.Management.Smo.ServerAdapter
Microsoft.SqlServer.Management.Smo.ServerAdapterBase
Microsoft.SqlServer.Management.Smo.ServerAdapter
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
The ServerAdapter type exposes the following members.
| Name | Description | |
|---|---|---|
 | AdHocRemoteQueriesEnabled | Gets or sets the value of the referenced property. (Inherited from ServerAdapterBase.) |
| Affinity64IOMask | Gets or sets the value of the referenced property. (Inherited from ServerAdapterBase.) |
| Affinity64Mask | Gets or sets the value of the referenced property. (Inherited from ServerAdapterBase.) |
| AffinityIOMask | Gets or sets the value of the referenced property. (Inherited from ServerAdapterBase.) |
| AffinityMask | Gets or sets the value of the referenced property. (Inherited from ServerAdapterBase.) |
| AgentXPsEnabled | Gets or sets the Boolean value that determines whether the referenced property is enabled. (Inherited from ServerAdapterBase.) |
| AllowUpdates | Gets or sets the Boolean value that determines whether the referenced property is enabled. (Inherited from ServerAdapterBase.) |
| AweEnabled | Gets or sets the Boolean value that determines whether the referenced property is enabled. (Inherited from ServerAdapterBase.) |
| BackupDirectory | Gets or sets the value of the referenced property. (Inherited from ServerAdapterBase.) |
| BlockedProcessThreshold | Gets or sets the value of the referenced property. (Inherited from ServerAdapterBase.) |
| BrowserServiceAccount | Gets or sets the value of the referenced property. (Inherited from ServerAdapterBase.) |
| BrowserStartMode | Gets or sets the value of the referenced property. (Inherited from ServerAdapterBase.) |
| C2AuditTracingEnabled | Gets or sets the Boolean value that determines whether the referenced property is enabled. (Inherited from ServerAdapterBase.) |
| ClrIntegrationEnabled | Gets or sets the Boolean value that determines whether the referenced property is enabled. (Inherited from ServerAdapterBase.) |
| Collation | Gets or sets the value of the referenced property. (Inherited from ServerAdapterBase.) |
| CommonCriteriaComplianceEnabled | Gets or sets the Boolean value that determines whether the referenced property is enabled. (Inherited from ServerAdapterBase.) |
| ContainmentEnabled | Enables or disables contained databases and authentication using Facets across a server instance. (Inherited from ServerAdapterBase.) |
| CostThresholdForParallelism | Gets or sets the value of the referenced property. (Inherited from ServerAdapterBase.) |
| CrossDBOwnershipChainingEnabled | Gets or sets the Boolean value that determines whether the referenced property is enabled. (Inherited from ServerAdapterBase.) |
| CursorThreshold | Gets or sets the Int32 value that determines the value of the referenced property. (Inherited from ServerAdapterBase.) |
| DatabaseMailEnabled | Gets or sets the Boolean value that determines whether the referenced property is enabled. (Inherited from ServerAdapterBase.) |
| DefaultBackupCompressionEnabled | Gets or sets the Boolean value that determines whether the referenced property is enabled. (Inherited from ServerAdapterBase.) |
| DefaultFile | Gets or sets the value of the referenced property. (Inherited from ServerAdapterBase.) |
| DefaultFullTextLanguage | Gets or sets the value of the referenced property. (Inherited from ServerAdapterBase.) |
| DefaultLanguage | Gets or sets the value of the referenced property. (Inherited from ServerAdapterBase.) |
| DefaultLog | Gets or sets the value of the referenced property. (Inherited from ServerAdapterBase.) |
| DefaultTraceEnabled | Gets or sets the Boolean value that determines whether the referenced property is enabled. (Inherited from ServerAdapterBase.) |
| DisallowResultsFromTriggers | Gets or sets a value that specifies whether SQL Server triggers can generate results. (Inherited from ServerAdapterBase.) |
| DynamicLocks | Gets or sets the value of the referenced property. (Inherited from ServerAdapterBase.) |
| ExtensibleKeyManagementEnabled | Gets or sets the Boolean value that determines whether the referenced property is enabled. (Inherited from ServerAdapterBase.) |
| FilestreamAccessLevel | Gets or sets the value of the referenced property. (Inherited from ServerAdapterBase.) |
| FilestreamLevel | Gets or sets the value of the referenced property. (Inherited from ServerAdapterBase.) |
| FilestreamShareName | Gets or sets the value of the referenced property. (Inherited from ServerAdapterBase.) |
| FillFactor | Gets or sets the value of the referenced property. (Inherited from ServerAdapterBase.) |
| FullTextCrawlBandwidthMax | Gets or sets the value of the referenced property. (Inherited from ServerAdapterBase.) |
| FullTextCrawlBandwidthMin | Gets or sets the value of the referenced property. (Inherited from ServerAdapterBase.) |
| FullTextCrawlRangeMax | Gets or sets the maximum number of partitions that SQL Server is allowed to use during a full index crawl. (Inherited from ServerAdapterBase.) |
| FullTextNotifyBandwidthMax | Gets or sets the value of the referenced property. (Inherited from ServerAdapterBase.) |
| FullTextNotifyBandwidthMin | Gets or sets the value of the referenced property. (Inherited from ServerAdapterBase.) |
| IndexCreateMemory | Gets or sets the value of the referenced property. (Inherited from ServerAdapterBase.) |
| InDoubtTransactionResolution | Gets or sets the value of the referenced property. (Inherited from ServerAdapterBase.) |
| InstallDataDirectory | Gets or sets the value of the referenced property. (Inherited from ServerAdapterBase.) |
| InstallSharedDirectory | Gets or sets the value of the referenced property. (Inherited from ServerAdapterBase.) |
| InstanceName | Gets or sets the value of the referenced property. (Inherited from ServerAdapterBase.) |
| LightweightPoolingEnabled | Gets or sets the Boolean value that determines whether the referenced property is enabled. (Inherited from ServerAdapterBase.) |
| LoginAuditLevel | Gets or sets the value of the referenced property. (Inherited from ServerAdapterBase.) |
| LoginMode | Gets or sets the value of the referenced property. (Inherited from ServerAdapterBase.) |
| MaxDegreeOfParallelism | Gets or sets the value of the referenced property. (Inherited from ServerAdapterBase.) |
| MaxServerMemory | Gets or sets the value of the referenced property. (Inherited from ServerAdapterBase.) |
| MaxWorkerThreads | Gets or sets the value of the referenced property. (Inherited from ServerAdapterBase.) |
| MediaRetention | Gets or sets the value of the referenced property. (Inherited from ServerAdapterBase.) |
| MinMemoryPerQuery | Gets or sets the value of the referenced property. (Inherited from ServerAdapterBase.) |
| MinServerMemory | Gets or sets the value of the referenced property. (Inherited from ServerAdapterBase.) |
| NamedPipesEnabled | Gets or sets the Boolean value that determines whether the referenced property is enabled. (Inherited from ServerAdapterBase.) |
| NestedTriggersEnabled | Gets or sets the Boolean value that determines whether the referenced property is enabled. (Inherited from ServerAdapterBase.) |
| NetworkPacketSize | Gets or sets the value of the referenced property. (Inherited from ServerAdapterBase.) |
| OleAutomationEnabled | Gets or sets the Boolean value that determines whether the referenced property is enabled. (Inherited from ServerAdapterBase.) |
| OpenObjects | Gets or sets the value of the referenced property. (Inherited from ServerAdapterBase.) |
| OptimizeAdhocWorkloads | Gets or sets a value that specifies whether optimization for ad hoc workloads is enabled. (Inherited from ServerAdapterBase.) |
| PrecomputeRank | Gets or sets the Boolean value that determines whether the referenced property is enabled. (Inherited from ServerAdapterBase.) |
| PriorityBoost | Gets or sets the Boolean value that determines whether the referenced property is enabled. (Inherited from ServerAdapterBase.) |
| ProtocolHandlerTimeout | Gets or sets the value of the referenced property. (Inherited from ServerAdapterBase.) |
| QueryGovernorCostLimit | Gets or sets the value of the referenced property. (Inherited from ServerAdapterBase.) |
| QueryWait | Gets or sets the value of the referenced property. (Inherited from ServerAdapterBase.) |
| RecoveryInterval | Gets or sets the value of the referenced property. (Inherited from ServerAdapterBase.) |
| RemoteAccessEnabled | Gets or sets the Boolean value that determines whether the referenced property is enabled. (Inherited from ServerAdapterBase.) |
| RemoteDacEnabled | Gets or sets the Boolean value that determines whether the referenced property is enabled. (Inherited from ServerAdapterBase.) |
| RemoteLoginTimeout | Gets or sets the value of the referenced property. (Inherited from ServerAdapterBase.) |
| RemoteProcTransEnabled | Gets or sets the Boolean value that determines whether the referenced property is enabled. (Inherited from ServerAdapterBase.) |
| RemoteQueryTimeout | Gets or sets the value of the referenced property. (Inherited from ServerAdapterBase.) |
| ReplicationMaxTextSize | Gets or sets the value of the referenced property. (Inherited from ServerAdapterBase.) |
| ReplicationXPsEnabled | Gets or sets the Boolean value that determines whether the referenced property is enabled. (Inherited from ServerAdapterBase.) |
| ScanForStartupProcedures | Gets or sets the Boolean value that determines whether the referenced property is enabled. (Inherited from ServerAdapterBase.) |
| Server | Gets the Server associated with the ServerAdapterBase. (Inherited from ServerAdapterBase.) |
| ServerTriggerRecursionEnabled | Gets or sets the Boolean value that determines whether the referenced property is enabled. (Inherited from ServerAdapterBase.) |
| ServiceName | Gets or sets the value of the referenced property. (Inherited from ServerAdapterBase.) |
| ServiceStartMode | Gets or sets the value of the referenced property. (Inherited from ServerAdapterBase.) |
| SetWorkingSetSize | Gets or sets the Boolean value that determines whether the referenced property is enabled. (Inherited from ServerAdapterBase.) |
| ShowAdvancedOptions | Gets or sets the Boolean value that determines whether the referenced property is enabled. (Inherited from ServerAdapterBase.) |
| SmoAndDmoXPsEnabled | Gets or sets the Boolean value that determines whether the referenced property is enabled. (Inherited from ServerAdapterBase.) |
| SqlDomainGroup | Gets or sets the value of the referenced property. (Inherited from ServerAdapterBase.) |
| SqlMailEnabled | Gets or sets the Boolean value that determines whether the referenced property is enabled. (Inherited from ServerAdapterBase.) |
| TcpEnabled | Gets or sets the Boolean value that determines whether the referenced property is enabled. (Inherited from ServerAdapterBase.) |
| TransformNoiseWords | Gets or sets the Boolean value that determines whether the referenced property is enabled. (Inherited from ServerAdapterBase.) |
| TwoDigitYearCutoff | Gets or sets the value of the referenced property. (Inherited from ServerAdapterBase.) |
| UserConnections | Gets or sets the value of the referenced property. (Inherited from ServerAdapterBase.) |
| UserInstancesEnabled | Gets or sets the Boolean value that determines whether the referenced property is enabled. (Inherited from ServerAdapterBase.) |
| UserInstanceTimeout | Gets or sets the value of the referenced property. (Inherited from ServerAdapterBase.) |
| UserOptions | Gets or sets the value of the referenced property. (Inherited from ServerAdapterBase.) |
| WebAssistantEnabled | Gets or sets the Boolean value that determines whether the referenced property is enabled. (Inherited from ServerAdapterBase.) |
| XPCmdShellEnabled | Gets or sets the Boolean value that determines whether the referenced property is enabled. (Inherited from ServerAdapterBase.) |
| Name | Description | |
|---|---|---|
| Alter | Updates any object property changes on the instance of SQL Server. (Inherited from ServerAdapterBase.) |
| Equals | (Inherited from Object.) |
| Finalize | (Inherited from Object.) |
| GetHashCode | (Inherited from Object.) |
| GetType | (Inherited from Object.) |
| MemberwiseClone | (Inherited from Object.) |
| Refresh | Updates the object. (Inherited from ServerAdapterBase.) |
| ToString | (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.
