共用方式為


ServerSetupAdapter Class

Definition

Adapter for AS SAC facet

public class ServerSetupAdapter : Microsoft.SqlServer.Management.Smo.ServerAdapterBase, Microsoft.SqlServer.Management.Facets.IDmfAdapter, Microsoft.SqlServer.Management.Sdk.Sfc.IDmfFacet, Microsoft.SqlServer.Management.Smo.IServerSetupFacet
type ServerSetupAdapter = class
    inherit ServerAdapterBase
    interface IDmfAdapter
    interface IServerSetupFacet
    interface IDmfFacet
Public Class ServerSetupAdapter
Inherits ServerAdapterBase
Implements IDmfAdapter, IDmfFacet, IServerSetupFacet
Inheritance
ServerSetupAdapter
Implements

Constructors

ServerSetupAdapter(Server)

Properties

AdHocRemoteQueriesEnabled (Inherited from ServerAdapterBase)
Affinity64IOMask (Inherited from ServerAdapterBase)
Affinity64Mask

Binds SQL Server disk I/O to a specified subset of CPUs. This option is available only on the 64-bit version of Microsoft SQL Server.

(Inherited from ServerAdapterBase)
AffinityIOMask

Binds SQL Server threads to a specified subset of CPUs.

(Inherited from ServerAdapterBase)
AffinityMask

Binds SQL Server disk I/O to a specified subset of CPUs.

(Inherited from ServerAdapterBase)
AgentDomainGroup

The JobServer AgentDomainGroup

AgentServiceAccount

The JobServer ServiceAccount

AgentStartMode

The JobServer ServiceStartMode

AgentXPsEnabled (Inherited from ServerAdapterBase)
AllowUpdates (Inherited from ServerAdapterBase)
AweEnabled (Inherited from ServerAdapterBase)
BackupDirectory (Inherited from ServerAdapterBase)
BlockedProcessThreshold (Inherited from ServerAdapterBase)
BrowserServiceAccount (Inherited from ServerAdapterBase)
BrowserStartMode (Inherited from ServerAdapterBase)
C2AuditTracingEnabled

Audits all attempts to access statements and objects. Writes attempts to a file in the SQL Server Data folder.

(Inherited from ServerAdapterBase)
ClrIntegrationEnabled (Inherited from ServerAdapterBase)
Collation (Inherited from ServerAdapterBase)
CommonCriteriaComplianceEnabled (Inherited from ServerAdapterBase)
ContainmentEnabled

Enables or disables contained databases and authentication using Facets, across a server instance.

(Inherited from ServerAdapterBase)
CostThresholdForParallelism

Specifies the threshold at which SQL Server creates and runs parallel plans for queries.

(Inherited from ServerAdapterBase)
CrossDBOwnershipChainingEnabled (Inherited from ServerAdapterBase)
CursorThreshold (Inherited from ServerAdapterBase)
DatabaseMailEnabled (Inherited from ServerAdapterBase)
DefaultBackupCompressionEnabled (Inherited from ServerAdapterBase)
DefaultFile (Inherited from ServerAdapterBase)
DefaultFullTextLanguage (Inherited from ServerAdapterBase)
DefaultLanguage (Inherited from ServerAdapterBase)
DefaultLog (Inherited from ServerAdapterBase)
DefaultTraceEnabled (Inherited from ServerAdapterBase)
DisallowResultsFromTriggers (Inherited from ServerAdapterBase)
DynamicLocks

Sets the maximum number of available locks. This option limits the amount of memory the Database Engine uses for locks.

(Inherited from ServerAdapterBase)
EngineServiceAccount

The ServiceAccount for the Sql Server Engine

ExtensibleKeyManagementEnabled (Inherited from ServerAdapterBase)
FilestreamAccessLevel (Inherited from ServerAdapterBase)
FilestreamLevel (Inherited from ServerAdapterBase)
FilestreamShareName (Inherited from ServerAdapterBase)
FillFactor (Inherited from ServerAdapterBase)
FullTextCrawlBandwidthMax (Inherited from ServerAdapterBase)
FullTextCrawlBandwidthMin (Inherited from ServerAdapterBase)
FullTextCrawlRangeMax (Inherited from ServerAdapterBase)
FullTextNotifyBandwidthMax (Inherited from ServerAdapterBase)
FullTextNotifyBandwidthMin (Inherited from ServerAdapterBase)
IndexCreateMemory (Inherited from ServerAdapterBase)
InDoubtTransactionResolution (Inherited from ServerAdapterBase)
InstallDataDirectory (Inherited from ServerAdapterBase)
InstallSharedDirectory (Inherited from ServerAdapterBase)
InstanceName

The instance name of this Server

(Inherited from ServerAdapterBase)
LightweightPoolingEnabled

Provides a means of reducing the system overhead that is associated with the excessive context switching that occurs sometimes in symmetric multiprocessing (SMP) environments.

(Inherited from ServerAdapterBase)
LoginAuditLevel

Sets auditing mode for tracking Logins that have logged with success/failure.

(Inherited from ServerAdapterBase)
LoginMode

SQL Server Authentication Mode

(Inherited from ServerAdapterBase)
MaxDegreeOfParallelism

Limits the number of processors that are used to run a single statement for each parallel plan execution.

(Inherited from ServerAdapterBase)
MaxServerMemory (Inherited from ServerAdapterBase)
MaxWorkerThreads

Configures the number of worker threads that are available to SQL Server processes.

(Inherited from ServerAdapterBase)
MediaRetention (Inherited from ServerAdapterBase)
MinMemoryPerQuery (Inherited from ServerAdapterBase)
MinServerMemory (Inherited from ServerAdapterBase)
NamedPipesEnabled (Inherited from ServerAdapterBase)
NestedTriggersEnabled (Inherited from ServerAdapterBase)
NetworkPacketSize

Sets the packet size (in bytes) that is used across the whole network.

(Inherited from ServerAdapterBase)
OleAutomationEnabled (Inherited from ServerAdapterBase)
OpenObjects

Sets the maximum number of database objects that can be open at one time on an instance of SQL Server 2000 Database objects are those objects that are defined in the sysobjects table: tables, views, rules, stored procedures, defaults, and triggers

(Inherited from ServerAdapterBase)
OptimizeAdhocWorkloads (Inherited from ServerAdapterBase)
PrecomputeRank (Inherited from ServerAdapterBase)
PriorityBoost (Inherited from ServerAdapterBase)
ProtocolHandlerTimeout (Inherited from ServerAdapterBase)
QueryGovernorCostLimit (Inherited from ServerAdapterBase)
QueryWait (Inherited from ServerAdapterBase)
RecoveryInterval (Inherited from ServerAdapterBase)
RemoteAccessEnabled (Inherited from ServerAdapterBase)
RemoteDacEnabled (Inherited from ServerAdapterBase)
RemoteDataArchiveEnabled

Flag indicating whether Stretch feature is enabled for the Server

(Inherited from ServerAdapterBase)
RemoteLoginTimeout (Inherited from ServerAdapterBase)
RemoteProcTransEnabled (Inherited from ServerAdapterBase)
RemoteQueryTimeout (Inherited from ServerAdapterBase)
ReplicationMaxTextSize (Inherited from ServerAdapterBase)
ReplicationXPsEnabled (Inherited from ServerAdapterBase)
ScanForStartupProcedures (Inherited from ServerAdapterBase)
Server (Inherited from ServerAdapterBase)
ServerTriggerRecursionEnabled (Inherited from ServerAdapterBase)
ServiceInstanceIdSuffix

The instance Id for this Server

ServiceName

Gets service name that the server instance runs under

(Inherited from ServerAdapterBase)
ServiceStartMode

Gets the startup mode for the service

(Inherited from ServerAdapterBase)
SetWorkingSetSize (Inherited from ServerAdapterBase)
ShowAdvancedOptions (Inherited from ServerAdapterBase)
SmoAndDmoXPsEnabled (Inherited from ServerAdapterBase)
SqlDomainGroup (Inherited from ServerAdapterBase)
SqlMailEnabled (Inherited from ServerAdapterBase)
TcpEnabled (Inherited from ServerAdapterBase)
TempdbLogPath

The log file path for the tempdb database

TempdbPrimaryFilePath

The PrimaryFilePath for the tempdb database.

TransformNoiseWords (Inherited from ServerAdapterBase)
TwoDigitYearCutoff (Inherited from ServerAdapterBase)
UserConnections (Inherited from ServerAdapterBase)
UserInstancesEnabled (Inherited from ServerAdapterBase)
UserInstanceTimeout (Inherited from ServerAdapterBase)
UserOptions (Inherited from ServerAdapterBase)
WebAssistantEnabled (Inherited from ServerAdapterBase)
WindowsUsersAndGroupsInSysadminRole
XPCmdShellEnabled (Inherited from ServerAdapterBase)

Methods

Alter() (Inherited from ServerAdapterBase)
Refresh()

Applies to