ServerAdapter Class
This class aggregates otherwise hidden server properties.
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
Microsoft.SqlServer.Management.Smo::ServerAdapterBase
Microsoft.SqlServer.Management.Smo::ServerAdapter
| Name | Description | |
|---|---|---|
![]() | ServerAdapter(Server^) | Initializes a new instance of the ServerAdapter class. |
| 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.) |
![]() | RemoteDataArchiveEnabled | Gets or Sets the remote data archive from server adapter.(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(Object^) | (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.
Any public static ( Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.



