ISqlServerOptions Members

Include Protected Members
Include Inherited Members

Represents SQL Server options.

The ISqlServerOptions type exposes the following members.

Methods

  Name Description
Public method AddAnnotation Adds an annotation. (Inherited from IModelAnnotationHolder.)
Public method Delete Deletes this instance from the model. (Inherited from IModelElement.)
Public method GetAnnotations Overloaded. Returns all attached annotations.
Public method GetAnnotations<TType> Overloaded.
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 Gets a permissions relationship collection. (Inherited from ISqlSecurable.)
Public method GetProperty<TProperty> Gets the specified property. (Inherited from IModelPropertyContainer.)
Public method GetRelatedDanglingRelationshipEntries Returns a list of the dangling relationship entries, where this element is on the left side. (Inherited from IModelElement.)
Public method GetRelatedElements Returns a list of the elements that are in a relationship with this element, where this element is on the left side. (Inherited from IModelElement.)
Public method GetRelatedRelationshipEntries Returns a list of the relationship entries, where this element is on the left side. (Inherited from IModelElement.)
Public method GetRelatingElements 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 GetRelatingRelationshipEntries Returns a list of the relationship entries, where this element is on the right side. (Inherited from IModelElement.)
Public method GetRelationship Returns the asked relationship. (Inherited from IModelElement.)
Public method GetRelationship<TRelating, TRelated> Returns the asked relationship. (Inherited from IModelElement.)
Public method GetRelationshipEntrySources Returns the list of relationship entry sources for a relationship entry. (Inherited from IScriptSourcedElement.)
Public method GetRelationships Returns a list of the relationships of this element. (Inherited from IModelElement.)
Public method IsDeleted Specifies whether the object is deleted. (Inherited from IModelElement.)
Public method IsExternal Specifies whether the object is external. (Inherited from IModelElement.)
Public method RemoveAnnotation Removes an annotation. (Inherited from IModelAnnotationHolder.)
Public method SetProperty<TProperty> Sets the specified property. (Inherited from IModelPropertyContainer.)

Top

Properties

  Name Description
Public property Affinity64Mask Gets or sets the affinity64 mask option.
Public property AffinityMask Gets or sets the affinity mask option.
Public property Collation Gets or sets the collation string.
Public property CostThresholdForParallelism Gets or sets the cost threshold for parallelism.
Public property CursorThreshold Gets or sets the cursor threshold.
Public property DefaultFillFactor Gets or sets the default fill factor.
Public property DefaultFulltextLanguage Gets or sets the default full-text language.
Public property DefaultLanguage Gets or sets the default language.
Public property DisableDefaultConstraintChecking Gets or sets whether to disable default constraint checking.
Public property DoAllowRemoteAccess Gets or sets whether to allow remote access.
Public property DoAllowUpdates Gets or sets whether to allow updates.
Public property ElementClass Gets the metadata class. (Inherited from IModelElement.)
Public property ElementSource Gets the element source for an element. (Inherited from IScriptSourcedElement.)
Public property ImplicitTransactions Gets or sets whether to allow implicit transactions.
Public property IndexCreateMemory Gets or sets index memory created.
Public property IsAnsiNullDefaultOff Gets or sets whether AnsiNull default is off.
Public property IsAnsiNullDefaultOn Gets or sets whether AnsiNull default is on.
Public property IsAnsiNullsOn Gets or sets whether AnsiNulls is on.
Public property IsAnsiPaddingOn Gets or sets whether AnsiPadding is on.
Public property IsAnsiWarningsOn Gets or sets whether AnsiWarnings is on.
Public property IsArithAbortOn Gets or sets whether ArithAbort is on.
Public property IsArithIgnoreOn Gets or sets whether ArithIgnore is on.
Public property IsAweEnabled Gets or sets whether Address Windowing Extensions is enabled.
Public property IsC2AuditModeOn Gets or sets whether C2 audit mode is on.
Public property IsConcatNullYieldsNullOn Gets or sets whether CONCAT_NULL_YIELDS_NULL is on.
Public property IsCrossDbOwnershipChainingOn Gets or sets whether cross-database ownership chaining is on.
Public property IsCursorCloseOnCommitOn Gets or sets whether cursor close on commit is on.
Public property IsLightweightPoolingOn Gets or sets whether lightweight pooling is on.
Public property IsNestedTriggersEnabled Gets or sets whether nested triggers is on.
Public property IsNocountOn Gets or sets whether no count is on.
Public property IsNumericRoundAbortOn Gets or sets whether NUMERIC_ROUNDABORT is on.
Public property IsPriorityBoostEnabled Gets or sets whether priority boost is enabled.
Public property IsQuotedIdentifierOn Gets or sets whether quoted identifier is on.
Public property IsRemoteProcTransactionEnabled Gets or sets whether remote process transactions are enabled.
Public property IsScanForStartupProcsEnabled Gets or sets whether a scan for startup processes is enabled.
Public property IsSetWorkingSetSizeEnabled Gets or sets whether setting working set size is enabled.
Public property IsShowAdvancedOptionEnabled Gets or sets whether showing advanced options is enabled.
Public property Locks Gets or sets locks.
Public property MaxDegreeOfParallelism Gets or sets the maximum degree of parallelism.
Public property MaxServerMemory Gets or sets maximum server memory.
Public property MaxTextReplSize Gets or sets the maximum text replacement size.
Public property MaxWorkerThreads Gets or sets the maximum worker threads.
Public property MediaRetention Gets or sets media retention.
Public property MinMemoryPerQuery Gets or sets minimum memory per query.
Public property MinServerMemory Gets or sets minimum server memory.
Public property Model Gets the model reference. (Inherited from IModelEntity.)
Public property Name Gets or sets the name of the IModelElement. (Inherited from IModelElement.)
Public property NetworkPacketSize Gets or sets network packet size.
Public property OpenObjects Gets or sets open objects.
Public property Permissions Gets a list of permissions. (Inherited from ISqlSecurable.)
Public property QueryGovernorCostlimit Gets or sets the query governor cost limit.
Public property QueryWait Gets or sets the query wait.
Public property RecoveryInterval Gets or sets the recovery interval.
Public property RemoteLoginTimeout Gets or sets the remote login timeout.
Public property RemoteQueryTimeout Gets or sets the remote query timeout.
Public property ResolutionStatus Gets or sets the value of the model element resolution status. (Inherited from IModelElement.)
Public property TransactionAbort Gets or sets transaction abort.
Public property TwoDigitYearCuttoff
Public property UserConnections Gets or sets the user connections.
Public property ValidationStatus Gets or sets the value of the model element validation status. (Inherited from IModelElement.)

Top

See Also

Reference

ISqlServerOptions Interface

Microsoft.Data.Schema.Sql.SchemaModel.SqlServer Namespace