ISql100ServerOptions Properties
Include Protected Members
Include Inherited Members
The ISql100ServerOptions type exposes the following members.
Properties
| Name | Description | |
|---|---|---|
.gif "Public property") |
AccessCheckCacheBucketCount | Gets or sets the value of the "access check cache bucket count" option for sp_configure. |
|
AccessCheckCacheQuota | Gets or sets the value of the "access check cache quota" option for sp_configure. |
|
Affinity64IOMask | Gets or sets a value that models the affinity 64 I/O mask setting. (Inherited from ISql90ServerOptions.) |
|
Affinity64Mask | Gets or sets a value that models the "affinity64 mask" sp_configure option. (Inherited from ISqlServerOptions.) |
|
AffinityIOMask | Gets or sets a value that models the affinity I/O mask setting. (Inherited from ISql90ServerOptions.) |
|
AffinityMask | Gets or sets a value that models the "affinity mask" sp_configure option. (Inherited from ISqlServerOptions.) |
|
BlockProcessThreshold | Gets or sets a value that models the block process threshold setting. (Inherited from ISql90ServerOptions.) |
|
Collation | Gets or sets the server collation. (Inherited from ISqlServerOptions.) |
|
CostThresholdForParallelism | Gets or sets a value that models the "cost threshold for parallelism" sp_configure option. (Inherited from ISqlServerOptions.) |
|
CursorThreshold | Gets or sets a value that models the "cursor threshold" sp_configure option. (Inherited from ISqlServerOptions.) |
|
DefaultFillFactor | Gets or sets a value that models the "fill factor" sp_configure option. (Inherited from ISqlServerOptions.) |
|
DefaultFulltextLanguage | Gets or sets a value that models the "default full-text language" sp_configure option. (Inherited from ISqlServerOptions.) |
|
DefaultLanguage | Gets or sets a value that models the "default language" sp_configure option. (Inherited from ISqlServerOptions.) |
|
DisableDefaultConstraintChecking | Gets or sets a value that models the DISABLE_DEF_CNST_CHK setting. (Inherited from ISqlServerOptions.) |
|
DisallowResultsFromTriggers | Gets or sets a value that models the disallow results from triggers setting. (Inherited from ISql90ServerOptions.) |
|
DoAllowRemoteAccess | Gets or sets a value that models the "allow remote access" sp_configure option. (Inherited from ISqlServerOptions.) |
|
DoAllowRemoteAdminConnections | Gets or sets a value that indicates whether remote administrator connections are enabled. (Inherited from ISql90ServerOptions.) |
|
DoAllowServerTriggerRecursion | Gets or sets a value that indicates whether server trigger recursion is enabled. (Inherited from ISql90ServerOptions.) |
|
DoAllowUpdates | Gets or sets a value that models the "allow updates" sp_configure option. (Inherited from ISqlServerOptions.) |
|
ElementClass | Gets the metadata class for an element. (Inherited from IModelElement.) |
|
FilestreamAccessLevel | Gets or sets the value of the "filestream_access_level" option for sp_configure. |
|
FtCrawlMaxBandwidth | Gets or sets a value that models the ft crawl max bandwidth setting. (Inherited from ISql90ServerOptions.) |
|
FtCrawlMinBandwidth | Gets or sets a value that models the ft crawl min bandwidth setting. (Inherited from ISql90ServerOptions.) |
|
FtNotifyMaxBandwidth | Gets or sets a value that models the ft notify max bandwidth setting. (Inherited from ISql90ServerOptions.) |
|
FtNotifyMinBandwidth | Gets or sets a value that models the ft notify min bandwidth setting. (Inherited from ISql90ServerOptions.) |
|
ImplicitTransactions | Gets or sets a value that models the default IMPLICIT_TRANSACTIONS setting. (Inherited from ISqlServerOptions.) |
|
IndexCreateMemory | Gets or sets a value that models the "index create memory" sp_configure option. (Inherited from ISqlServerOptions.) |
|
InDoubtXactResolution | Gets or sets a value that models the in doubt xact resolution setting. (Inherited from ISql90ServerOptions.) |
|
IsAdHocDistributedQueriesEnabled | Gets or sets a value that models the ad hoc distributed queries setting. (Inherited from ISql90ServerOptions.) |
|
IsAgentXPsStarted | Gets or sets a value that models the agent XPs setting. (Inherited from ISql90ServerOptions.) |
|
IsAnsiNullDefaultOff | Gets or sets a value that models the ANSI_NULL_DFLT_OFF setting. (Inherited from ISqlServerOptions.) |
|
IsAnsiNullDefaultOn | Gets or sets a value that models the ANSI_NULL_DFLT_ON setting. (Inherited from ISqlServerOptions.) |
|
IsAnsiNullsOn | Gets or sets a value that models the default ANSI_NULLS setting. (Inherited from ISqlServerOptions.) |
|
IsAnsiPaddingOn | Gets or sets a value that models the default ANSI_PADDING setting. (Inherited from ISqlServerOptions.) |
|
IsAnsiWarningsOn | Gets or sets a value that models the default ANSI_WARNINGS setting. (Inherited from ISqlServerOptions.) |
|
IsArithAbortOn | Gets or sets a value that models the default ARITHABORT setting. (Inherited from ISqlServerOptions.) |
|
IsArithIgnoreOn | Gets or sets a value that models the default ARITHIGNORE setting. (Inherited from ISqlServerOptions.) |
|
IsAweEnabled | Gets or sets a value that models the "awe enabled" sp_configure option. (Inherited from ISqlServerOptions.) |
|
IsBackupCompressionDefaultOn | Gets or sets the value of the "backup compression default" option for sp_configure. |
|
IsC2AuditModeOn | Gets or sets a value that models the "C2 audit mode" sp_configure option. (Inherited from ISqlServerOptions.) |
|
IsClrEnabled | Gets or sets a value that indicates whether SQL CLR support is enabled. (Inherited from ISql90ServerOptions.) |
|
IsCommonCriteriaComplianceEnabled | Gets or sets a value that models the common criteria compliance setting. (Inherited from ISql90ServerOptions.) |
|
IsConcatNullYieldsNullOn | Gets or sets a value that models the default CONCAT_NULL_YIELDS_NULL setting. (Inherited from ISqlServerOptions.) |
|
IsCrossDbOwnershipChainingOn | Gets or sets a value that models the "cross db ownership chaining" sp_configure option. (Inherited from ISqlServerOptions.) |
|
IsCursorCloseOnCommitOn | Gets or sets a value that models the default CURSOR_CLOSE_ON_COMMIT setting. (Inherited from ISqlServerOptions.) |
|
IsDatabaseMailXPsEnabled | Gets or sets a value that models the database mail XPs setting. (Inherited from ISql90ServerOptions.) |
|
IsDefaultTraceEnabled | Gets or sets a value that models the default trace setting. (Inherited from ISql90ServerOptions.) |
|
IsEkmProviderEnabled | Gets or sets the value of the "EKM provider enabled" option for sp_configure. |
|
IsLightweightPoolingOn | Gets or sets a value that models the "lightweight pooling" sp_configure option. (Inherited from ISqlServerOptions.) |
|
IsNestedTriggersEnabled | Gets or sets a value that models the "nested triggers" sp_configure option. (Inherited from ISqlServerOptions.) |
|
IsNocountOn | Gets or sets a value that models the default NOCOUNT setting. (Inherited from ISqlServerOptions.) |
|
IsNumericRoundAbortOn | Gets or sets a value that models the default NUMERIC_ROUND_ABORT setting. (Inherited from ISqlServerOptions.) |
|
IsOleAutomationProceduresEnabled | Gets or sets a value that models the OLE Automation procedures setting. (Inherited from ISql90ServerOptions.) |
|
IsPrecomputeRankEnabled | Gets or sets a value that models the precompute rank setting. (Inherited from ISql90ServerOptions.) |
|
IsPriorityBoostEnabled | Gets or sets a value that models the "priority boost" sp_configure option. (Inherited from ISqlServerOptions.) |
|
IsQuotedIdentifierOn | Gets or sets a value that models the default QUOTED_IDENTIFIER setting. (Inherited from ISqlServerOptions.) |
|
IsRemoteProcTransactionEnabled | Gets or sets a value that models the "remote proc trans" sp_configure option. (Inherited from ISqlServerOptions.) |
|
IsReplicationXPsEnabled | Gets or sets a value that models the replication XPs setting. (Inherited from ISql90ServerOptions.) |
|
IsScanForStartupProcsEnabled | Gets or sets a value that models the "scan for startup procs" sp_configure option. (Inherited from ISqlServerOptions.) |
|
IsSetWorkingSetSizeEnabled | Gets or sets a value that models the "set working set size" sp_configure option. (Inherited from ISqlServerOptions.) |
|
IsShowAdvancedOptionEnabled | Gets or sets a value that models the "show advanced options" sp_configure option. (Inherited from ISqlServerOptions.) |
|
IsSmoAndDmoXPsEnabled | Gets or sets a value that models the Server Management Objects (SMO) and Distributed Management Objects (DMO) XPs setting. (Inherited from ISql90ServerOptions.) |
|
IsSqlMailXPsEnabled | Gets or sets a value that models the SQL mail XPs setting. (Inherited from ISql90ServerOptions.) |
|
IsTransformNoiseWordsEnabled | Gets or sets a value that models the transform noise words setting. (Inherited from ISql90ServerOptions.) |
|
IsUserInstancesEnabled | Gets or sets a value that indicates whether user instances are enabled. (Inherited from ISql90ServerOptions.) |
|
IsWebAssistantProceduresEnabled | Gets or sets a value that indicates whether Web assistant procedures are enabled. (Inherited from ISql90ServerOptions.) |
|
IsXPCmdsShellEnabled | Gets or sets a value that models the XP cmdshell setting. (Inherited from ISql90ServerOptions.) |
|
Locks | Gets or sets a value that models the "locks" sp_configure option. (Inherited from ISqlServerOptions.) |
|
MaxDegreeOfParallelism | Gets or sets a value that models the "max degree of parallelism" sp_configure option. (Inherited from ISqlServerOptions.) |
|
MaxFulltextCrawlRange | Gets or sets a value that models the max fulltext crawl range setting. (Inherited from ISql90ServerOptions.) |
|
MaxServerMemory | Gets or sets a value that models the "max server memory" sp_configure option. (Inherited from ISqlServerOptions.) |
|
MaxTextReplSize | Gets or sets a value that models the "max text repl size" sp_configure option. (Inherited from ISqlServerOptions.) |
|
MaxWorkerThreads | Gets or sets a value that models the "max worker threads" sp_configure option. (Inherited from ISqlServerOptions.) |
|
MediaRetention | Gets or sets a value that models the "media retention" sp_configure option. (Inherited from ISqlServerOptions.) |
|
MinMemoryPerQuery | Gets or sets a value that models the "min memory per query" sp_configure option. (Inherited from ISqlServerOptions.) |
|
MinServerMemory | Gets or sets a value that models the "min server memory" sp_configure option. (Inherited from ISqlServerOptions.) |
|
Model | Gets the model reference. (Inherited from IModelEntity.) |
|
Name | Gets or sets the name of the element. (Inherited from IModelElement.) |
|
NetworkPacketSize | Gets or sets a value that models the "network packet size" sp_configure option. (Inherited from ISqlServerOptions.) |
|
OpenObjects | Gets or sets a value that models the "open objects" sp_configure option. (Inherited from ISqlServerOptions.) |
|
OptimizeForAdhocWorkloads | Gets or sets the value of the "optimize for ad hoc workloads" option for sp_configure. |
|
Permissions | Gets the list of permissions that apply to this object. (Inherited from ISqlSecurable.) |
|
PHTimeout | Gets or sets a value that models the PH time-out setting. (Inherited from ISql90ServerOptions.) |
|
PrimarySource | Gets information about the primary source for the element. (Inherited from IScriptSourcedModelElement.) |
|
QueryGovernorCostlimit | Gets or sets a value that models the "query governor cost limit" sp_configure option. (Inherited from ISqlServerOptions.) |
|
QueryWait | Gets or sets a value that models the "query wait" sp_configure option. (Inherited from ISqlServerOptions.) |
|
RecoveryInterval | Gets or sets a value that models the "recovery interval" sp_configure option. (Inherited from ISqlServerOptions.) |
|
RemoteLoginTimeout | Gets or sets a value that models the "remote login timeout" sp_configure option. (Inherited from ISqlServerOptions.) |
|
RemoteQueryTimeout | Gets or sets a value that models the "remote query timeout" sp_configure option. (Inherited from ISqlServerOptions.) |
|
ResolutionStatus | Gets or sets the value of the model element resolution status. (Inherited from IModelElement.) |
|
SecondarySources | Gets a list of secondary sources for the element. (Inherited from IScriptSourcedModelElement.) |
|
SourceCodePositions | Gets the list of sources that define this element. (Inherited from IModelElement.) |
|
TransactionAbort | Gets or sets a value that models the XACT_ABORT setting. (Inherited from ISqlServerOptions.) |
|
TwoDigitYearCuttoff | Gets or sets a value that models the "two digit year cutoff" sp_configure option. (Inherited from ISqlServerOptions.) |
|
UserConnections | Gets or sets a value that models the "user connections" sp_configure option. (Inherited from ISqlServerOptions.) |
|
UserInstanceTimeout | Gets or sets the time-out value for user instances. (Inherited from ISql90ServerOptions.) |
|
ValidationStatus | Gets or sets the value of the model element validation status. (Inherited from IModelElement.) |
Top