ServerSecurityAdapter Class

Definition

Namespace:

Microsoft.SqlServer.Management.Smo

Assembly:

Microsoft.SqlServer.Smo.dll

Package:

Microsoft.SqlServer.SqlManagementObjects v160.2004021.0

Relational Engine Security. This facet has some logical properties and it needs its own Refresh and Alter. It inherits from the ServerAdapterBase.

public class ServerSecurityAdapter : Microsoft.SqlServer.Management.Smo.ServerAdapterBase, Microsoft.SqlServer.Management.Facets.IDmfAdapter, Microsoft.SqlServer.Management.Sdk.Sfc.IDmfFacet, Microsoft.SqlServer.Management.Smo.IServerSecurityFacet

type ServerSecurityAdapter = class
    inherit ServerAdapterBase
    interface IDmfAdapter
    interface IServerSecurityFacet
    interface IDmfFacet

Public Class ServerSecurityAdapter
Inherits ServerAdapterBase
Implements IDmfAdapter, IDmfFacet, IServerSecurityFacet

Inheritance

Object

ServerAdapterBase

ServerSecurityAdapter

Implements

IDmfAdapter IDmfFacet IServerSecurityFacet

Constructors

ServerSecurityAdapter(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)
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)
CmdExecRightsForSystemAdminsOnly
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)
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)
ProxyAccountEnabled
ProxyAccountIsGrantedToPublicRole
PublicServerRoleIsGrantedPermissions	The server permissions that are granted to the public server role.
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)
ReplaceAlertTokensEnabled
ReplicationMaxTextSize	(Inherited from ServerAdapterBase)
ReplicationXPsEnabled	(Inherited from ServerAdapterBase)
ScanForStartupProcedures	(Inherited from ServerAdapterBase)
Server	(Inherited from ServerAdapterBase)
ServerTriggerRecursionEnabled	(Inherited from ServerAdapterBase)
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)
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)
XPCmdShellEnabled	(Inherited from ServerAdapterBase)

Methods

Alter()

Refresh()