Configuration Members
The Configuration class contains the configuration information for the instance of Microsoft SQL Server.
The following tables list the members exposed by the Configuration type.
Public Properties
Nom | Description | |
---|---|---|
AdHocDistributedQueriesEnabled | Gets the ConfigProperty object that is used to set the ad hoc distributed queries 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. | |
C2AuditMode | Gets the ConfigProperty object that is used to set the C2 audit mode 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. | |
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. | |
FillFactor | Gets the ConfigProperty object that is used to set the fill factor configuration option. | |
IndexCreateMemory | Gets the ConfigProperty object that is used to set the index create memory 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. | |
Parent | Gets the Server object that is the parent of the Configuration object. (inherited from 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. | |
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. | |
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. |
Haut de la page
Public Methods
(see also Protected Methods )
Nom | Description | |
---|---|---|
Alter | Overloaded. Updates the Configuration object property changes on the instance of Microsoft SQL Server. (inherited from ConfigurationBase) | |
Equals | Overloaded. (inherited from Object ) | |
GetHashCode | (inherited from Object ) | |
GetType | (inherited from Object ) | |
ReferenceEquals | (inherited from Object ) | |
Refresh | Refreshes the Configuration object properties. (inherited from ConfigurationBase) | |
ToString | (inherited from Object ) |
Haut de la page
Protected Methods
Nom | Description | |
---|---|---|
Finalize | (inherited from Object ) | |
MemberwiseClone | (inherited from Object ) |
Haut de la page
Voir aussi
Référence
Configuration Class
Microsoft.SqlServer.Management.Smo Namespace
Autres ressources
Configuring SQL Server in SMO
Définition des options de configuration de serveur
sp_configure (Transact-SQL)