This topic has not yet been rated - Rate this topic

ServerAdapterBase Class

SQL Server 2012

A ServerAdapterBase object is a base class that is used in the construction of the ServerAdapter class.

System.Object
  Microsoft.SqlServer.Management.Smo.ServerAdapterBase
    Microsoft.SqlServer.Management.Smo.ServerAdapter
    Microsoft.SqlServer.Management.Smo.ServerConfigurationAdapter
    Microsoft.SqlServer.Management.Smo.ServerSecurityAdapter
    Microsoft.SqlServer.Management.Smo.ServerSelectionAdapter
    Microsoft.SqlServer.Management.Smo.ServerSetupAdapter
    Microsoft.SqlServer.Management.Smo.ServerSurfaceAreaAdapter

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

Syntax

C++

JScript

public abstract class ServerAdapterBase : IAlterable, 
	IRefreshable

The ServerAdapterBase type exposes the following members.

Constructors

	Name	Description
	ServerAdapterBase	Initializes a new instance of the ServerAdapterBase object.

Top

Properties

	Name	Description
	AdHocRemoteQueriesEnabled	Gets or sets the value of the referenced property.
	Affinity64IOMask	Gets or sets the value of the referenced property.
	Affinity64Mask	Gets or sets the value of the referenced property.
	AffinityIOMask	Gets or sets the value of the referenced property.
	AffinityMask	Gets or sets the value of the referenced property.
	AgentXPsEnabled	Gets or sets the Boolean value that determines whether the referenced property is enabled.
	AllowUpdates	Gets or sets the Boolean value that determines whether the referenced property is enabled.
	AweEnabled	Gets or sets the Boolean value that determines whether the referenced property is enabled.
	BackupDirectory	Gets or sets the value of the referenced property.
	BlockedProcessThreshold	Gets or sets the value of the referenced property.
	BrowserServiceAccount	Gets or sets the value of the referenced property.
	BrowserStartMode	Gets or sets the value of the referenced property.
	C2AuditTracingEnabled	Gets or sets the Boolean value that determines whether the referenced property is enabled.
	ClrIntegrationEnabled	Gets or sets the Boolean value that determines whether the referenced property is enabled.
	Collation	Gets or sets the value of the referenced property.
	CommonCriteriaComplianceEnabled	Gets or sets the Boolean value that determines whether the referenced property is enabled.
	ContainmentEnabled	Enables or disables contained databases and authentication using Facets across a server instance.
	CostThresholdForParallelism	Gets or sets the value of the referenced property.
	CrossDBOwnershipChainingEnabled	Gets or sets the Boolean value that determines whether the referenced property is enabled.
	CursorThreshold	Gets or sets the Int32 value that determines the value of the referenced property.
	DatabaseMailEnabled	Gets or sets the Boolean value that determines whether the referenced property is enabled.
	DefaultBackupCompressionEnabled	Gets or sets the Boolean value that determines whether the referenced property is enabled.
	DefaultFile	Gets or sets the value of the referenced property.
	DefaultFullTextLanguage	Gets or sets the value of the referenced property.
	DefaultLanguage	Gets or sets the value of the referenced property.
	DefaultLog	Gets or sets the value of the referenced property.
	DefaultTraceEnabled	Gets or sets the Boolean value that determines whether the referenced property is enabled.
	DisallowResultsFromTriggers	Gets or sets a value that specifies whether SQL Server triggers can generate results.
	DynamicLocks	Gets or sets the value of the referenced property.
	ExtensibleKeyManagementEnabled	Gets or sets the Boolean value that determines whether the referenced property is enabled.
	FilestreamAccessLevel	Gets or sets the value of the referenced property.
	FilestreamLevel	Gets or sets the value of the referenced property.
	FilestreamShareName	Gets or sets the value of the referenced property.
	FillFactor	Gets or sets the value of the referenced property.
	FullTextCrawlBandwidthMax	Gets or sets the value of the referenced property.
	FullTextCrawlBandwidthMin	Gets or sets the value of the referenced property.
	FullTextCrawlRangeMax	Gets or sets the maximum number of partitions that SQL Server is allowed to use during a full index crawl.
	FullTextNotifyBandwidthMax	Gets or sets the value of the referenced property.
	FullTextNotifyBandwidthMin	Gets or sets the value of the referenced property.
	IndexCreateMemory	Gets or sets the value of the referenced property.
	InDoubtTransactionResolution	Gets or sets the value of the referenced property.
	InstallDataDirectory	Gets or sets the value of the referenced property.
	InstallSharedDirectory	Gets or sets the value of the referenced property.
	InstanceName	Gets or sets the value of the referenced property.
	LightweightPoolingEnabled	Gets or sets the Boolean value that determines whether the referenced property is enabled.
	LoginAuditLevel	Gets or sets the value of the referenced property.
	LoginMode	Gets or sets the value of the referenced property.
	MaxDegreeOfParallelism	Gets or sets the value of the referenced property.
	MaxServerMemory	Gets or sets the value of the referenced property.
	MaxWorkerThreads	Gets or sets the value of the referenced property.
	MediaRetention	Gets or sets the value of the referenced property.
	MinMemoryPerQuery	Gets or sets the value of the referenced property.
	MinServerMemory	Gets or sets the value of the referenced property.
	NamedPipesEnabled	Gets or sets the Boolean value that determines whether the referenced property is enabled.
	NestedTriggersEnabled	Gets or sets the Boolean value that determines whether the referenced property is enabled.
	NetworkPacketSize	Gets or sets the value of the referenced property.
	OleAutomationEnabled	Gets or sets the Boolean value that determines whether the referenced property is enabled.
	OpenObjects	Gets or sets the value of the referenced property.
	OptimizeAdhocWorkloads	Gets or sets a value that specifies whether optimization for ad hoc workloads is enabled.
	PrecomputeRank	Gets or sets the Boolean value that determines whether the referenced property is enabled.
	PriorityBoost	Gets or sets the Boolean value that determines whether the referenced property is enabled.
	ProtocolHandlerTimeout	Gets or sets the value of the referenced property.
	QueryGovernorCostLimit	Gets or sets the value of the referenced property.
	QueryWait	Gets or sets the value of the referenced property.
	RecoveryInterval	Gets or sets the value of the referenced property.
	RemoteAccessEnabled	Gets or sets the Boolean value that determines whether the referenced property is enabled.
	RemoteDacEnabled	Gets or sets the Boolean value that determines whether the referenced property is enabled.
	RemoteLoginTimeout	Gets or sets the value of the referenced property.
	RemoteProcTransEnabled	Gets or sets the Boolean value that determines whether the referenced property is enabled.
	RemoteQueryTimeout	Gets or sets the value of the referenced property.
	ReplicationMaxTextSize	Gets or sets the value of the referenced property.
	ReplicationXPsEnabled	Gets or sets the Boolean value that determines whether the referenced property is enabled.
	ScanForStartupProcedures	Gets or sets the Boolean value that determines whether the referenced property is enabled.
	Server	Gets the Server associated with the ServerAdapterBase.
	ServerTriggerRecursionEnabled	Gets or sets the Boolean value that determines whether the referenced property is enabled.
	ServiceName	Gets or sets the value of the referenced property.
	ServiceStartMode	Gets or sets the value of the referenced property.
	SetWorkingSetSize	Gets or sets the Boolean value that determines whether the referenced property is enabled.
	ShowAdvancedOptions	Gets or sets the Boolean value that determines whether the referenced property is enabled.
	SmoAndDmoXPsEnabled	Gets or sets the Boolean value that determines whether the referenced property is enabled.
	SqlDomainGroup	Gets or sets the value of the referenced property.
	SqlMailEnabled	Gets or sets the Boolean value that determines whether the referenced property is enabled.
	TcpEnabled	Gets or sets the Boolean value that determines whether the referenced property is enabled.
	TransformNoiseWords	Gets or sets the Boolean value that determines whether the referenced property is enabled.
	TwoDigitYearCutoff	Gets or sets the value of the referenced property.
	UserConnections	Gets or sets the value of the referenced property.
	UserInstancesEnabled	Gets or sets the Boolean value that determines whether the referenced property is enabled.
	UserInstanceTimeout	Gets or sets the value of the referenced property.
	UserOptions	Gets or sets the value of the referenced property.
	WebAssistantEnabled	Gets or sets the Boolean value that determines whether the referenced property is enabled.
	XPCmdShellEnabled	Gets or sets the Boolean value that determines whether the referenced property is enabled.

Top

Methods

	Name	Description
	Alter	Updates any object property changes on the instance of SQL Server.
	Equals	(Inherited from Object.)
	Finalize	(Inherited from Object.)
	GetHashCode	(Inherited from Object.)
	GetType	(Inherited from Object.)
	MemberwiseClone	(Inherited from Object.)
	Refresh	Updates the object.
	ToString	(Inherited from Object.)

Top

Remarks

Thread Safety

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

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.

Reference

Microsoft.SqlServer.Management.Smo Namespace

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD