ISqlServerOptions Interface

Models the settings for an instance of SQL Server.

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

Syntax

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

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

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

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

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

The ISqlServerOptions type exposes the following members.

Properties

	Name	Description
	Affinity64Mask	Gets or sets a value that models the "affinity64 mask" sp_configure option.
	AffinityMask	Gets or sets a value that models the "affinity mask" sp_configure option.
	Collation	Gets or sets the server collation.
	CostThresholdForParallelism	Gets or sets a value that models the "cost threshold for parallelism" sp_configure option.
	CursorThreshold	Gets or sets a value that models the "cursor threshold" sp_configure option.
	DefaultFillFactor	Gets or sets a value that models the "fill factor" sp_configure option.
	DefaultFulltextLanguage	Gets or sets a value that models the "default full-text language" sp_configure option.
	DefaultLanguage	Gets or sets a value that models the "default language" sp_configure option.
	DisableDefaultConstraintChecking	Gets or sets a value that models the DISABLE_DEF_CNST_CHK setting.
	DoAllowRemoteAccess	Gets or sets a value that models the "allow remote access" sp_configure option.
	DoAllowUpdates	Gets or sets a value that models the "allow updates" sp_configure option.
	ElementClass	Gets the metadata class for an element. (Inherited from IModelElement.)
	ImplicitTransactions	Gets or sets a value that models the default IMPLICIT_TRANSACTIONS setting.
	IndexCreateMemory	Gets or sets a value that models the "index create memory" sp_configure option.
	IsAnsiNullDefaultOff	Gets or sets a value that models the ANSI_NULL_DFLT_OFF setting.
	IsAnsiNullDefaultOn	Gets or sets a value that models the ANSI_NULL_DFLT_ON setting.
	IsAnsiNullsOn	Gets or sets a value that models the default ANSI_NULLS setting.
	IsAnsiPaddingOn	Gets or sets a value that models the default ANSI_PADDING setting.
	IsAnsiWarningsOn	Gets or sets a value that models the default ANSI_WARNINGS setting.
	IsArithAbortOn	Gets or sets a value that models the default ARITHABORT setting.
	IsArithIgnoreOn	Gets or sets a value that models the default ARITHIGNORE setting.
	IsAweEnabled	Gets or sets a value that models the "awe enabled" sp_configure option.
	IsC2AuditModeOn	Gets or sets a value that models the "C2 audit mode" sp_configure option.
	IsConcatNullYieldsNullOn	Gets or sets a value that models the default CONCAT_NULL_YIELDS_NULL setting.
	IsCrossDbOwnershipChainingOn	Gets or sets a value that models the "cross db ownership chaining" sp_configure option.
	IsCursorCloseOnCommitOn	Gets or sets a value that models the default CURSOR_CLOSE_ON_COMMIT setting.
	IsLightweightPoolingOn	Gets or sets a value that models the "lightweight pooling" sp_configure option.
	IsNestedTriggersEnabled	Gets or sets a value that models the "nested triggers" sp_configure option.
	IsNocountOn	Gets or sets a value that models the default NOCOUNT setting.
	IsNumericRoundAbortOn	Gets or sets a value that models the default NUMERIC_ROUND_ABORT setting.
	IsPriorityBoostEnabled	Gets or sets a value that models the "priority boost" sp_configure option.
	IsQuotedIdentifierOn	Gets or sets a value that models the default QUOTED_IDENTIFIER setting.
	IsRemoteProcTransactionEnabled	Gets or sets a value that models the "remote proc trans" sp_configure option.
	IsScanForStartupProcsEnabled	Gets or sets a value that models the "scan for startup procs" sp_configure option.
	IsSetWorkingSetSizeEnabled	Gets or sets a value that models the "set working set size" sp_configure option.
	IsShowAdvancedOptionEnabled	Gets or sets a value that models the "show advanced options" sp_configure option.
	Locks	Gets or sets a value that models the "locks" sp_configure option.
	MaxDegreeOfParallelism	Gets or sets a value that models the "max degree of parallelism" sp_configure option.
	MaxServerMemory	Gets or sets a value that models the "max server memory" sp_configure option.
	MaxTextReplSize	Gets or sets a value that models the "max text repl size" sp_configure option.
	MaxWorkerThreads	Gets or sets a value that models the "max worker threads" sp_configure option.
	MediaRetention	Gets or sets a value that models the "media retention" sp_configure option.
	MinMemoryPerQuery	Gets or sets a value that models the "min memory per query" sp_configure option.
	MinServerMemory	Gets or sets a value that models the "min server memory" sp_configure option.
	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.
	OpenObjects	Gets or sets a value that models the "open objects" sp_configure option.
	Permissions	Gets the list of permissions that apply to this object. (Inherited from ISqlSecurable.)
	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.
	QueryWait	Gets or sets a value that models the "query wait" sp_configure option.
	RecoveryInterval	Gets or sets a value that models the "recovery interval" sp_configure option.
	RemoteLoginTimeout	Gets or sets a value that models the "remote login timeout" sp_configure option.
	RemoteQueryTimeout	Gets or sets a value that models the "remote query timeout" sp_configure option.
	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.
	TwoDigitYearCuttoff	Gets or sets a value that models the "two digit year cutoff" sp_configure option.
	UserConnections	Gets or sets a value that models the "user connections" sp_configure option.
	ValidationStatus	Gets or sets the value of the model element validation status. (Inherited from IModelElement.)

Top

Methods

	Name	Description
	AddAnnotation	Adds the given annotation to this element. (Inherited from IModelAnnotationHolder.)
	Delete	Deletes this instance from the model. (Inherited from IModelElement.)
	GetAnnotations()	Returns a list of annotations attached to this element. (Inherited from IModelAnnotationHolder.)
	GetAnnotations(Type)	Returns a list of attached annotations of the given type. (Inherited from IModelAnnotationHolder.)
	GetAnnotations(ModelIdentifier)	Returns a list of attached annotations that have the given identifier. (Inherited from IModelAnnotationHolder.)
	GetAnnotations(ModelIdentifier, Type)	(Inherited from IModelAnnotationHolder.)
	GetAnnotations<TType>()	Returns all attached model annotations that implement the given annotation type and have the specified model identifier. (Inherited from IModelAnnotationHolder.)
	GetAnnotations<TType>(ModelIdentifier)	(Inherited from IModelAnnotationHolder.)
	GetComposingChildren	Returns a list of composing children for this element. (Inherited from IModelElement.)
	GetHierarchicalChildren	Returns a list of hierarchical children for this element. (Inherited from IModelElement.)
	GetOwnerInfo	Returns information about the element owner. (Inherited from IModelElement.)
	GetPermissionsRelationship	Returns an IModelReverseMultiRelationship between this and the associated ISqlPermissionStatement. (Inherited from ISqlSecurable.)
	GetProperty<TProperty>	Gets the specified property. (Inherited from IModelPropertyContainer.)
	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.)
	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.)
	GetReferencedRelationshipEntries	Returns a list of the relationship entries, where this element is on the left side. (Inherited from IModelElement.)
	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.)
	GetReferencingRelationshipEntries	Returns a list of the relationship entries, where this element is on the right side. (Inherited from IModelElement.)
	GetRelationship(ModelRelationshipClass)	Returns the requested relationship by using the provided metadata. (Inherited from IModelElement.)
	GetRelationship<TFrom, TTo>(ModelRelationshipClass)	Returns a relationship where the two related elements are of the specified types. (Inherited from IModelElement.)
	GetRelationshipEntrySources	Returns a collection of source information about the given relationship. (Inherited from IScriptSourcedModelElement.)
	GetRelationships	Returns a list of the relationships in this element. (Inherited from IModelElement.)
	IsDeleted	Specifies whether the object is deleted. (Inherited from IModelElement.)
	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.)
	RemoveAnnotation	Removes the specified annotation from this model element. (Inherited from IModelAnnotationHolder.)
	SetProperty<TProperty>	Sets the specified property. (Inherited from IModelPropertyContainer.)

Top

See Also

Reference

Microsoft.Data.Schema.Sql.SchemaModel Namespace