This topic has not yet been rated - Rate this topic

ServerSelectionAdapter Class

SQL Server 2008 R2

SQL Server 2012

Provides selection options for an instance of SQL Server.

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

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

Syntax

C++

JScript

public class ServerSelectionAdapter : ServerAdapterBase, 
	IDmfAdapter, IServerSelectionFacet, IDmfFacet

The ServerSelectionAdapter type exposes the following members.

Constructors

	Name	Description
	ServerSelectionAdapter	Initializes a new instance of the ServerSelectionAdapter 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.)
	BuildNumber	Gets the build number of the server.
	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.)
	Edition	Gets the edition of the server.
	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.)
	IsCaseSensitive	Gets a Boolean value that specifies whether the server uses case-sensitive syntax.
	Language	Gets a string value that specifies the language used by the server.
	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.)
	OSVersion	Gets a string value that specifies the operating system version for the computer hosting the server.
	Platform	Gets a string value that specifies the platform of the operating system hosting the server.
	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.)
	VersionMajor	Gets an Int32 value that contains the major digits of the version number.
	VersionMinor	Gets an Int32 value that contains the minor digits of the version number.
	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

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