Hinweis
Für den Zugriff auf diese Seite ist eine Autorisierung erforderlich. Sie können versuchen, sich anzumelden oder das Verzeichnis zu wechseln.
Für den Zugriff auf diese Seite ist eine Autorisierung erforderlich. Sie können versuchen, das Verzeichnis zu wechseln.
Exposes methods to refresh and alter server configuration properties.
Vererbungshierarchie
System.Object
Microsoft.SqlServer.Management.Smo.ServerAdapterBase
Microsoft.SqlServer.Management.Smo.ServerConfigurationAdapter
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
Syntax
'Declaration
Public Class ServerConfigurationAdapter _
Inherits ServerAdapterBase _
Implements IServerPerformanceFacet, IDmfAdapter, IServerConfigurationFacet, IDmfFacet
'Usage
Dim instance As ServerConfigurationAdapter
public class ServerConfigurationAdapter : ServerAdapterBase,
IServerPerformanceFacet, IDmfAdapter, IServerConfigurationFacet, IDmfFacet
public ref class ServerConfigurationAdapter : public ServerAdapterBase,
IServerPerformanceFacet, IDmfAdapter, IServerConfigurationFacet, IDmfFacet
type ServerConfigurationAdapter =
class
inherit ServerAdapterBase
interface IServerPerformanceFacet
interface IDmfAdapter
interface IServerConfigurationFacet
interface IDmfFacet
end
public class ServerConfigurationAdapter extends ServerAdapterBase implements IServerPerformanceFacet, IDmfAdapter, IServerConfigurationFacet, IDmfFacet
Der ServerConfigurationAdapter-Typ macht folgende Elemente verfügbar.
Konstruktoren
| Name | Beschreibung | |
|---|---|---|
![]() |
ServerConfigurationAdapter | Initializes a new instance of the ServerConfigurationAdapter class. |
Zum Anfang
Eigenschaften
| Name | Beschreibung | |
|---|---|---|
![]() |
AdHocRemoteQueriesEnabled | Gets or sets the value of the referenced property. (Geerbt von ServerAdapterBase.) |
![]() |
Affinity64IOMask | Gets or sets the value of the referenced property. (Geerbt von ServerAdapterBase.) |
![]() |
Affinity64Mask | Gets or sets the value of the referenced property. (Geerbt von ServerAdapterBase.) |
![]() |
AffinityIOMask | Gets or sets the value of the referenced property. (Geerbt von ServerAdapterBase.) |
![]() |
AffinityMask | Gets or sets the value of the referenced property. (Geerbt von ServerAdapterBase.) |
![]() |
AgentXPsEnabled | Gets or sets the Boolean value that determines whether the referenced property is enabled. (Geerbt von ServerAdapterBase.) |
![]() |
AllowUpdates | Gets or sets the Boolean value that determines whether the referenced property is enabled. (Geerbt von ServerAdapterBase.) |
![]() |
AweEnabled | Gets or sets the Boolean value that determines whether the referenced property is enabled. (Geerbt von ServerAdapterBase.) |
![]() |
BackupDirectory | Gets or sets the value of the referenced property. (Geerbt von ServerAdapterBase.) |
![]() |
BlockedProcessThreshold | Gets or sets the value of the referenced property. (Geerbt von ServerAdapterBase.) |
![]() |
BrowserServiceAccount | Gets or sets the value of the referenced property. (Geerbt von ServerAdapterBase.) |
![]() |
BrowserStartMode | Gets or sets the value of the referenced property. (Geerbt von ServerAdapterBase.) |
![]() |
C2AuditTracingEnabled | Gets or sets the Boolean value that determines whether the referenced property is enabled. (Geerbt von ServerAdapterBase.) |
![]() |
ClrIntegrationEnabled | Gets or sets the Boolean value that determines whether the referenced property is enabled. (Geerbt von ServerAdapterBase.) |
![]() |
Collation | Gets or sets the value of the referenced property. (Geerbt von ServerAdapterBase.) |
![]() |
CommonCriteriaComplianceEnabled | Gets or sets the Boolean value that determines whether the referenced property is enabled. (Geerbt von ServerAdapterBase.) |
![]() |
ContainmentEnabled | Enables or disables contained databases and authentication using Facets across a server instance. (Geerbt von ServerAdapterBase.) |
![]() |
CostThresholdForParallelism | Gets or sets the value of the referenced property. (Geerbt von ServerAdapterBase.) |
![]() |
CrossDBOwnershipChainingEnabled | Gets or sets the Boolean value that determines whether the referenced property is enabled. (Geerbt von ServerAdapterBase.) |
![]() |
CursorThreshold | Gets or sets the Int32 value that determines the value of the referenced property. (Geerbt von ServerAdapterBase.) |
![]() |
DatabaseMailEnabled | Gets or sets the Boolean value that determines whether the referenced property is enabled. (Geerbt von ServerAdapterBase.) |
![]() |
DefaultBackupCompressionEnabled | Gets or sets the Boolean value that determines whether the referenced property is enabled. (Geerbt von ServerAdapterBase.) |
![]() |
DefaultFile | Gets or sets the value of the referenced property. (Geerbt von ServerAdapterBase.) |
![]() |
DefaultFullTextLanguage | Gets or sets the value of the referenced property. (Geerbt von ServerAdapterBase.) |
![]() |
DefaultLanguage | Gets or sets the value of the referenced property. (Geerbt von ServerAdapterBase.) |
![]() |
DefaultLog | Gets or sets the value of the referenced property. (Geerbt von ServerAdapterBase.) |
![]() |
DefaultTraceEnabled | Gets or sets the Boolean value that determines whether the referenced property is enabled. (Geerbt von ServerAdapterBase.) |
![]() |
DisallowResultsFromTriggers | Gets or sets a value that specifies whether SQL Server triggers can generate results. (Geerbt von ServerAdapterBase.) |
![]() |
DynamicLocks | Gets or sets the value of the referenced property. (Geerbt von ServerAdapterBase.) |
![]() |
ExtensibleKeyManagementEnabled | Gets or sets the Boolean value that determines whether the referenced property is enabled. (Geerbt von ServerAdapterBase.) |
![]() |
FilestreamAccessLevel | Gets or sets the value of the referenced property. (Geerbt von ServerAdapterBase.) |
![]() |
FilestreamLevel | Gets or sets the value of the referenced property. (Geerbt von ServerAdapterBase.) |
![]() |
FilestreamShareName | Gets or sets the value of the referenced property. (Geerbt von ServerAdapterBase.) |
![]() |
FillFactor | Gets or sets the value of the referenced property. (Geerbt von ServerAdapterBase.) |
![]() |
FullTextCrawlBandwidthMax | Gets or sets the value of the referenced property. (Geerbt von ServerAdapterBase.) |
![]() |
FullTextCrawlBandwidthMin | Gets or sets the value of the referenced property. (Geerbt von ServerAdapterBase.) |
![]() |
FullTextCrawlRangeMax | Gets or sets the maximum number of partitions that SQL Server is allowed to use during a full index crawl. (Geerbt von ServerAdapterBase.) |
![]() |
FullTextNotifyBandwidthMax | Gets or sets the value of the referenced property. (Geerbt von ServerAdapterBase.) |
![]() |
FullTextNotifyBandwidthMin | Gets or sets the value of the referenced property. (Geerbt von ServerAdapterBase.) |
![]() |
IndexCreateMemory | Gets or sets the value of the referenced property. (Geerbt von ServerAdapterBase.) |
![]() |
InDoubtTransactionResolution | Gets or sets the value of the referenced property. (Geerbt von ServerAdapterBase.) |
![]() |
InstallDataDirectory | Gets or sets the value of the referenced property. (Geerbt von ServerAdapterBase.) |
![]() |
InstallSharedDirectory | Gets or sets the value of the referenced property. (Geerbt von ServerAdapterBase.) |
![]() |
InstanceName | Gets or sets the value of the referenced property. (Geerbt von ServerAdapterBase.) |
![]() |
LightweightPoolingEnabled | Gets or sets the Boolean value that determines whether the referenced property is enabled. (Geerbt von ServerAdapterBase.) |
![]() |
LoginAuditLevel | Gets or sets the value of the referenced property. (Geerbt von ServerAdapterBase.) |
![]() |
LoginMode | Gets or sets the value of the referenced property. (Geerbt von ServerAdapterBase.) |
![]() |
MaxDegreeOfParallelism | Gets or sets the value of the referenced property. (Geerbt von ServerAdapterBase.) |
![]() |
MaxServerMemory | Gets or sets the value of the referenced property. (Geerbt von ServerAdapterBase.) |
![]() |
MaxWorkerThreads | Gets or sets the value of the referenced property. (Geerbt von ServerAdapterBase.) |
![]() |
MediaRetention | Gets or sets the value of the referenced property. (Geerbt von ServerAdapterBase.) |
![]() |
MinMemoryPerQuery | Gets or sets the value of the referenced property. (Geerbt von ServerAdapterBase.) |
![]() |
MinServerMemory | Gets or sets the value of the referenced property. (Geerbt von ServerAdapterBase.) |
![]() |
NamedPipesEnabled | Gets or sets the Boolean value that determines whether the referenced property is enabled. (Geerbt von ServerAdapterBase.) |
![]() |
NestedTriggersEnabled | Gets or sets the Boolean value that determines whether the referenced property is enabled. (Geerbt von ServerAdapterBase.) |
![]() |
NetworkPacketSize | Gets or sets the value of the referenced property. (Geerbt von ServerAdapterBase.) |
![]() |
OleAutomationEnabled | Gets or sets the Boolean value that determines whether the referenced property is enabled. (Geerbt von ServerAdapterBase.) |
![]() |
OpenObjects | Gets or sets the value of the referenced property. (Geerbt von ServerAdapterBase.) |
![]() |
OptimizeAdhocWorkloads | Gets or sets a value that specifies whether optimization for ad hoc workloads is enabled. (Geerbt von ServerAdapterBase.) |
![]() |
PrecomputeRank | Gets or sets the Boolean value that determines whether the referenced property is enabled. (Geerbt von ServerAdapterBase.) |
![]() |
PriorityBoost | Gets or sets the Boolean value that determines whether the referenced property is enabled. (Geerbt von ServerAdapterBase.) |
![]() |
ProtocolHandlerTimeout | Gets or sets the value of the referenced property. (Geerbt von ServerAdapterBase.) |
![]() |
QueryGovernorCostLimit | Gets or sets the value of the referenced property. (Geerbt von ServerAdapterBase.) |
![]() |
QueryWait | Gets or sets the value of the referenced property. (Geerbt von ServerAdapterBase.) |
![]() |
RecoveryInterval | Gets or sets the value of the referenced property. (Geerbt von ServerAdapterBase.) |
![]() |
RemoteAccessEnabled | Gets or sets the Boolean value that determines whether the referenced property is enabled. (Geerbt von ServerAdapterBase.) |
![]() |
RemoteDacEnabled | Gets or sets the Boolean value that determines whether the referenced property is enabled. (Geerbt von ServerAdapterBase.) |
![]() |
RemoteLoginTimeout | Gets or sets the value of the referenced property. (Geerbt von ServerAdapterBase.) |
![]() |
RemoteProcTransEnabled | Gets or sets the Boolean value that determines whether the referenced property is enabled. (Geerbt von ServerAdapterBase.) |
![]() |
RemoteQueryTimeout | Gets or sets the value of the referenced property. (Geerbt von ServerAdapterBase.) |
![]() |
ReplicationMaxTextSize | Gets or sets the value of the referenced property. (Geerbt von ServerAdapterBase.) |
![]() |
ReplicationXPsEnabled | Gets or sets the Boolean value that determines whether the referenced property is enabled. (Geerbt von ServerAdapterBase.) |
![]() |
ScanForStartupProcedures | Gets or sets the Boolean value that determines whether the referenced property is enabled. (Geerbt von ServerAdapterBase.) |
![]() |
Server | Gets the Server associated with the ServerAdapterBase. (Geerbt von ServerAdapterBase.) |
![]() |
ServerTriggerRecursionEnabled | Gets or sets the Boolean value that determines whether the referenced property is enabled. (Geerbt von ServerAdapterBase.) |
![]() |
ServiceName | Gets or sets the value of the referenced property. (Geerbt von ServerAdapterBase.) |
![]() |
ServiceStartMode | Gets or sets the value of the referenced property. (Geerbt von ServerAdapterBase.) |
![]() |
SetWorkingSetSize | Gets or sets the Boolean value that determines whether the referenced property is enabled. (Geerbt von ServerAdapterBase.) |
![]() |
ShowAdvancedOptions | Gets or sets the Boolean value that determines whether the referenced property is enabled. (Geerbt von ServerAdapterBase.) |
![]() |
SmoAndDmoXPsEnabled | Gets or sets the Boolean value that determines whether the referenced property is enabled. (Geerbt von ServerAdapterBase.) |
![]() |
SqlDomainGroup | Gets or sets the value of the referenced property. (Geerbt von ServerAdapterBase.) |
![]() |
SqlMailEnabled | Gets or sets the Boolean value that determines whether the referenced property is enabled. (Geerbt von ServerAdapterBase.) |
![]() |
TcpEnabled | Gets or sets the Boolean value that determines whether the referenced property is enabled. (Geerbt von ServerAdapterBase.) |
![]() |
TransformNoiseWords | Gets or sets the Boolean value that determines whether the referenced property is enabled. (Geerbt von ServerAdapterBase.) |
![]() |
TwoDigitYearCutoff | Gets or sets the value of the referenced property. (Geerbt von ServerAdapterBase.) |
![]() |
UserConnections | Gets or sets the value of the referenced property. (Geerbt von ServerAdapterBase.) |
![]() |
UserInstancesEnabled | Gets or sets the Boolean value that determines whether the referenced property is enabled. (Geerbt von ServerAdapterBase.) |
![]() |
UserInstanceTimeout | Gets or sets the value of the referenced property. (Geerbt von ServerAdapterBase.) |
![]() |
UserOptions | Gets or sets the value of the referenced property. (Geerbt von ServerAdapterBase.) |
![]() |
WebAssistantEnabled | Gets or sets the Boolean value that determines whether the referenced property is enabled. (Geerbt von ServerAdapterBase.) |
![]() |
XPCmdShellEnabled | Gets or sets the Boolean value that determines whether the referenced property is enabled. (Geerbt von ServerAdapterBase.) |
Zum Anfang
Methoden
| Name | Beschreibung | |
|---|---|---|
![]() |
Alter | Alters configuration settings. (Überschreibt ServerAdapterBase.Alter().) |
![]() |
Equals | (Geerbt von Object.) |
![]() |
Finalize | (Geerbt von Object.) |
![]() |
GetHashCode | (Geerbt von Object.) |
![]() |
GetType | (Geerbt von Object.) |
![]() |
MemberwiseClone | (Geerbt von Object.) |
![]() |
Refresh | Refreshes configuration settings. (Überschreibt ServerAdapterBase.Refresh().) |
![]() |
ToString | (Geerbt von Object.) |
Zum Anfang
Hinweise
This class inherits from ServerAdapterBase and overrides its Refresh and Alter functions.
Threadsicherheit
Alle öffentlichen static (Shared in Visual Basic)-Elemente dieses Typs sind Threadsicher. Für Instanzelemente wird die Threadsicherheit nicht gewährleistet.
.gif)
.gif)
.gif)
.gif)