ISql100ServerOptions Interface

  • Article

Models the settings on a server instance.

Namespace:  Microsoft.Data.Schema.Sql.SchemaModel
Assembly:  Microsoft.Data.Schema.Sql (in Microsoft.Data.Schema.Sql.dll)

Syntax

'Declaration
Public Interface ISql100ServerOptions _
    Inherits ISql90ServerOptions, ISqlServerOptions, ISqlSecurable, ISqlModelElement,  _
    IScriptSourcedModelElement, IModelElement, IModelPropertyContainer, IModelEntity, IModelAnnotationHolder

public interface ISql100ServerOptions : ISql90ServerOptions, 
    ISqlServerOptions, ISqlSecurable, ISqlModelElement, IScriptSourcedModelElement, IModelElement, 
    IModelPropertyContainer, IModelEntity, IModelAnnotationHolder

public interface class ISql100ServerOptions : ISql90ServerOptions, 
    ISqlServerOptions, ISqlSecurable, ISqlModelElement, IScriptSourcedModelElement, IModelElement, 
    IModelPropertyContainer, IModelEntity, IModelAnnotationHolder

type ISql100ServerOptions =  
    interface
        interface ISql90ServerOptions
        interface ISqlServerOptions
        interface ISqlSecurable
        interface ISqlModelElement
        interface IScriptSourcedModelElement
        interface IModelElement
        interface IModelPropertyContainer
        interface IModelEntity
        interface IModelAnnotationHolder
    end

public interface ISql100ServerOptions extends ISql90ServerOptions, ISqlServerOptions, ISqlSecurable, ISqlModelElement, IScriptSourcedModelElement, IModelElement, IModelPropertyContainer, IModelEntity, IModelAnnotationHolder

The ISql100ServerOptions type exposes the following members.

Properties

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

Top

Methods

  Name Description
Public method AddAnnotation Adds the given annotation to this element. (Inherited from IModelAnnotationHolder.)
Public method Delete Deletes this instance from the model. (Inherited from IModelElement.)
Public method GetAnnotations() Returns a list of annotations attached to this element. (Inherited from IModelAnnotationHolder.)
Public method GetAnnotations(Type) Returns a list of attached annotations of the given type. (Inherited from IModelAnnotationHolder.)
Public method GetAnnotations(ModelIdentifier) Returns a list of attached annotations that have the given identifier. (Inherited from IModelAnnotationHolder.)
Public method GetAnnotations(ModelIdentifier, Type) (Inherited from IModelAnnotationHolder.)
Public method GetAnnotations<TType>() Returns all attached model annotations that implement the given annotation type and have the specified model identifier. (Inherited from IModelAnnotationHolder.)
Public method GetAnnotations<TType>(ModelIdentifier) (Inherited from IModelAnnotationHolder.)
Public method GetComposingChildren Returns a list of composing children for this element. (Inherited from IModelElement.)
Public method GetHierarchicalChildren Returns a list of hierarchical children for this element. (Inherited from IModelElement.)
Public method GetOwnerInfo Returns information about the element owner. (Inherited from IModelElement.)
Public method GetPermissionsRelationship Returns an IModelReverseMultiRelationship between this and the associated ISqlPermissionStatement. (Inherited from ISqlSecurable.)
Public method GetProperty<TProperty> Gets the specified property. (Inherited from IModelPropertyContainer.)
Public method GetReferencedDanglingRelationshipEntries Returns a list of the relationship entries, where this element is on the left side and there is either no element on the right side of the relationship, or the element on the right does not exist in the model. (Inherited from IModelElement.)
Public method GetReferencedElements Returns a list of the elements that are in a relationship with this element, where this element is on the left side of the relationship. (Inherited from IModelElement.)
Public method GetReferencedRelationshipEntries Returns a list of the relationship entries, where this element is on the left side. (Inherited from IModelElement.)
Public method GetReferencingElements Returns a list of the elements that are in a relationship with this element, where this element is on the right side. (Inherited from IModelElement.)
Public method GetReferencingRelationshipEntries Returns a list of the relationship entries, where this element is on the right side. (Inherited from IModelElement.)
Public method GetRelationship(ModelRelationshipClass) Returns the requested relationship by using the provided metadata. (Inherited from IModelElement.)
Public method GetRelationship<TFrom, TTo>(ModelRelationshipClass) Returns a relationship where the two related elements are of the specified types. (Inherited from IModelElement.)
Public method GetRelationshipEntrySources Returns a collection of source information about the given relationship. (Inherited from IScriptSourcedModelElement.)
Public method GetRelationships Returns a list of the relationships in this element. (Inherited from IModelElement.)
Public method IsDeleted Specifies whether the object is deleted. (Inherited from IModelElement.)
Public method IsExternal Returns a value that indicates whether the object was loaded from an external source and is not a part of the schema model. (Inherited from IModelElement.)
Public method RemoveAnnotation Removes the specified annotation from this model element. (Inherited from IModelAnnotationHolder.)
Public method SetProperty<TProperty> Sets the specified property. (Inherited from IModelPropertyContainer.)

Top

See Also

Reference

Microsoft.Data.Schema.Sql.SchemaModel Namespace