Configuration-Member
The Configuration class contains the configuration information for the instance of SQL Server.
Der Configuration-Typ macht die folgenden Member verfügbar.
Methoden
| Name | Beschreibung | |
|---|---|---|
.gif "Öffentliche Methode") |
Alter() () () () | Updates the Configuration object property changes on the instance of SQL Server. (Geerbt von ConfigurationBase.) |
|
Alter(Boolean) | Updates the Configuration object property changes on the instance of SQL Server. (Geerbt von ConfigurationBase.) |
|
Equals | (Geerbt von Object.) |
.gif "Geschützte Methode") |
Finalize | (Geerbt von Object.) |
|
GetHashCode | (Geerbt von Object.) |
|
GetType | (Geerbt von Object.) |
|
MemberwiseClone | (Geerbt von Object.) |
|
Refresh | Refreshes the Configuration object properties. (Geerbt von ConfigurationBase.) |
|
ToString | (Geerbt von Object.) |
Zum Anfang
Eigenschaften
| Name | Beschreibung | |
|---|---|---|
.gif "Öffentliche Eigenschaft") |
AdHocDistributedQueriesEnabled | Gets the ConfigProperty object that is used to set the ad hoc distributed queries configuration option. |
|
Affinity64IOMask | Gets the ConfigProperty object that is used to set the affinity 64 IO mask configuration option. |
|
Affinity64Mask | Gets the ConfigProperty object that is used to set the affinity 64 mask configuration option. |
|
AffinityIOMask | Gets the ConfigProperty object that is used to set the affinity IO mask configuration option. |
|
AffinityMask | Gets the ConfigProperty object that is used to set the affinity mask configuration option. |
|
AgentXPsEnabled | Gets the ConfigProperty object that is used to set the agent XPs enabled configuration option. |
|
AllowUpdates | Gets the ConfigProperty object that is used to set the allow updates configuration option. |
|
AweEnabled | Gets the ConfigProperty object that is used to set the AWE enabled configuration option. |
|
BlockedProcessThreshold | Gets the ConfigProperty object that sets the blocked process threshold configuration option. |
|
C2AuditMode | Gets the ConfigProperty object that is used to set the C2 audit mode configuration option. |
|
CommonCriteriaComplianceEnabled | Gets the ConfigProperty object that is used to set the common criteria compliance enabled configuration option. |
|
CostThresholdForParallelism | Gets the ConfigProperty object that is used to set the cost threshold for parallelism configuration option. |
|
CrossDBOwnershipChaining | Gets the ConfigProperty object that is used to set the cross DB ownership chaining configuration option. |
|
CursorThreshold | Gets the ConfigProperty object that is used to set the cursor threshold configuration option. |
|
DatabaseMailEnabled | Gets the ConfigProperty object that is used to set the database mail enabled configuration option. |
|
DefaultBackupCompression | Gets the ConfigProperty object that is used to set the default backup compression configuration option. |
|
DefaultFullTextLanguage | Gets the ConfigProperty object that is used to set default full text language configuration option. |
|
DefaultLanguage | Gets the ConfigProperty object that is used to set the default language configuration option. |
|
DefaultTraceEnabled | Gets the ConfigProperty object that is used to set the default trace enabled configuration option. |
|
DisallowResultsFromTriggers | Gets the ConfigProperty object that is used to set the disallow results from triggers configuration option. |
|
ExtensibleKeyManagementEnabled | Gets the ConfigProperty object that is used to set the extensible key management enabled configuration option. |
|
FilestreamAccessLevel | Gets the ConfigProperty object that sets the filestream access level configuration option. |
|
FillFactor | Gets the ConfigProperty object that is used to set the fill factor configuration option. |
|
FullTextCrawlBandwidthMax | Gets the ConfigProperty object that is used to set the full text crawl bandwith max configuration option. |
|
FullTextCrawlBandwidthMin | Gets the ConfigProperty object that is used to set the full text crawl bandwith min configuration option. |
|
FullTextCrawlRangeMax | Gets the ConfigProperty object that is used to set the full text crawl range max configuration option. |
|
FullTextNotifyBandwidthMax | Gets the ConfigProperty object that is used to set the full text notify bandwith max configuration option. |
|
FullTextNotifyBandwidthMin | Gets the ConfigProperty object that is used to set the full text notify bandwith min configuration option. |
|
IndexCreateMemory | Gets the ConfigProperty object that is used to set the index create memory configuration option. |
|
InDoubtTransactionResolution | Gets the ConfigProperty object that is used to set the in doubt transaction resolution configuration option. |
|
IsSqlClrEnabled | Gets the ConfigProperty object that is used to set the is SQL CLR enabled configuration option. |
|
LightweightPooling | Gets the ConfigProperty object that is used to set the lightweight pooling configuration option. |
|
Locks | Gets the ConfigProperty object that is used to set the locks configuration option. |
|
MaxDegreeOfParallelism | Gets the ConfigProperty object that is used to set the max degree of parallelism configuration option. |
|
MaxServerMemory | Gets the ConfigProperty object that is used to set the max server memory configuration option. |
|
MaxWorkerThreads | Gets the ConfigProperty object that is used to set the max worker threads configuration option. |
|
MediaRetention | Gets the ConfigProperty object that is used to set the media retention configuration option. |
|
MinMemoryPerQuery | Gets the ConfigProperty object that is used to set the min memory per query configuration option. |
|
MinServerMemory | Gets the ConfigProperty object that is used to set the min server memory configuration option. |
|
NestedTriggers | Gets the ConfigProperty object that is used to set the nested triggers configuration option. |
|
NetworkPacketSize | Gets the ConfigProperty object that is used to set the network packet size configuration option. |
|
OleAutomationProceduresEnabled | Gets the ConfigProperty object that is used to set the OLE automation procedures enabled configuration option. |
|
OpenObjects | Gets the ConfigProperty object that is used to set the open objects configuration option. |
|
OptimizeAdhocWorkloads | Gets the ConfigProperty object that sets the optimize ad hoc workloads configuration option. |
|
Parent | Gets the Server object that is the parent of the Configuration object. (Geerbt von ConfigurationBase.) |
|
PrecomputeRank | Gets the ConfigProperty object that is used to set the precompute rank configuration option. |
|
PriorityBoost | Gets the ConfigProperty object that is used to set the priority boost configuration option. |
|
Properties | Returns a collection of Property objects. The PropertyCollection collection represents the properties of the Configuration object. |
|
ProtocolHandlerTimeout | Gets the ConfigProperty object that is used to set the protocol handler timeoutconfiguration option. |
|
QueryGovernorCostLimit | Gets the ConfigProperty object that is used to set the query governor cost limit option. |
|
QueryWait | Gets the ConfigProperty object that is used to set the query wait configuration option. |
|
RecoveryInterval | Gets the ConfigProperty object that is used to set the recovery interval configuration option. |
|
RemoteAccess | Gets the ConfigProperty object that is used to set the remote access configuration option. |
|
RemoteDacConnectionsEnabled | Gets the ConfigProperty object that is used to set the remote DAC connections enabled configuration option. |
|
RemoteLoginTimeout | Gets the ConfigProperty object that is used to set the remote login timeout configuration option. |
|
RemoteProcTrans | Gets the ConfigProperty object that is used to set the remote proc trans configuration option. |
|
RemoteQueryTimeout | Gets the ConfigProperty object that is used to set the remote query timeout configuration option. |
|
ReplicationMaxTextSize | Gets the ConfigProperty object that is used to set the replication max text size configuration option. |
|
ReplicationXPsEnabled | Gets the ConfigProperty object that is used to set the replication XPs enabled configuration option. |
|
ScanForStartupProcedures | Gets the ConfigProperty object that is used to set the scan for startup procedures configuration option. |
|
ServerTriggerRecursionEnabled | Gets the ConfigProperty object that is used to set the server trigger recursion enabled configuration option. |
|
SetWorkingSetSize | Gets the ConfigProperty object that is used to set the set working set size configuration option. |
|
ShowAdvancedOptions | Gets the ConfigProperty object that is used to set the show advanced options configuration option. |
|
SmoAndDmoXPsEnabled | Gets the ConfigProperty object that is used to set the SMO and DMO XPs enabled configuration option. |
|
SqlMailXPsEnabled | Gets the ConfigProperty object that is used to set the SQL mail XPs enabled configuration option. |
|
TransformNoiseWords | Gets the ConfigProperty object that is used to set the transform noise words configuration option. |
|
TwoDigitYearCutoff | Gets the ConfigProperty object that is used to set the two digit year cutoff configuration option. |
|
UserConnections | Gets the ConfigProperty object that is used to set the user connections configuration option. |
|
UserInstancesEnabled | Gets the ConfigProperty object that is used to set the user instances enabled configuration option. |
|
UserInstanceTimeout | Gets the ConfigProperty object that is used to set the user instance timeout configuration option. |
|
UserOptions | Gets the ConfigProperty object that is used to set the user options configuration option. |
|
WebXPsEnabled | Gets the ConfigProperty object that is used to set the web XPs enabled configuration option. |
|
XPCmdShellEnabled | Gets the ConfigProperty object that is used to set the XP cmd shell enabled configuration option. |
Zum Anfang