ServerAdapter Class

This class aggregates otherwise hidden server properties.

Inheritance Hierarchy

System.Object
  Microsoft.SqlServer.Management.Smo.ServerAdapterBase
    Microsoft.SqlServer.Management.Smo.ServerAdapter

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Syntax

'Declaration
Public Class ServerAdapter _
    Inherits ServerAdapterBase _
    Implements IDmfAdapter, IServerAuditFacet, IDmfFacet
'Usage
Dim instance As ServerAdapter

public class ServerAdapter : ServerAdapterBase, 
    IDmfAdapter, IServerAuditFacet, IDmfFacet

public ref class ServerAdapter : public ServerAdapterBase, 
    IDmfAdapter, IServerAuditFacet, IDmfFacet

type ServerAdapter =  
    class
        inherit ServerAdapterBase
        interface IDmfAdapter
        interface IServerAuditFacet
        interface IDmfFacet
    end

public class ServerAdapter extends ServerAdapterBase implements IDmfAdapter, IServerAuditFacet, IDmfFacet

The ServerAdapter type exposes the following members.

Constructors

	Name	Description
	ServerAdapter	Initializes a new instance of the ServerAdapter 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.)
	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	Updates any object property changes on the instance of SQL Server. (Inherited from ServerAdapterBase.)
	Equals	(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.)

Top

Remarks

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.

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