ServerConfigurationAdapter Class

Exposes methods to refresh and alter server configuration properties.

Inheritance Hierarchy

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

The ServerConfigurationAdapter type exposes the following members.

Constructors

	Name	Description
	ServerConfigurationAdapter	Initializes a new instance of the ServerConfigurationAdapter class.

Top

Properties

	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.)

Top

Methods

	Name	Description
	Alter	Alters configuration settings. (Overrides ServerAdapterBase.Alter().)
	Equals	(Inherited from Object.)
	Finalize	(Inherited from Object.)
	GetHashCode	(Inherited from Object.)
	GetType	(Inherited from Object.)
	MemberwiseClone	(Inherited from Object.)
	Refresh	Refreshes configuration settings. (Overrides ServerAdapterBase.Refresh().)
	ToString	(Inherited from Object.)

Top

Remarks

This class inherits from ServerAdapterBase and overrides its Refresh and Alter functions.

Thread Safety

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

See Also

Reference

Microsoft.SqlServer.Management.Smo Namespace