This topic has not yet been rated - Rate this topic

UserOptions.DisableDefaultConstraintCheck Property

SQL Server 2012

Gets or sets the Boolean property value that specifies whether interim deferred violation checking is used when connecting to a server running Microsoft SQL Server version 6.x.

Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Syntax

C++

JScript

[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.Deploy, 
	"false")]
public bool DisableDefaultConstraintCheck { get; set; }

Property Value

Type: System.Boolean
A Boolean value that specifies the whether interim deferred violation checking is used on servers running SQL Server version 6.x.If True, interim deferred violation checking is used.If False (default), interim deferred violation checking is not used.

Remarks

This property is included for backward compatibility only. The functionality of this statement is now built into SQL Server.

Examples

Configuring SQL Server in SMO

Reference

UserOptions Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Configuring SQL Server in SMO

NIB user options Option

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD