Share via

UserOptions.DisableDefaultConstraintCheck Property

  • Article

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

'Declaration
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.Deploy,  _
    "false")> _
Public Property DisableDefaultConstraintCheck As Boolean 
    Get 
    Set
'Usage
Dim instance As UserOptions 
Dim value As Boolean 

value = instance.DisableDefaultConstraintCheck

instance.DisableDefaultConstraintCheck = value

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

[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::Standalone|SfcPropertyFlags::Deploy, 
    L"false")]
public:
property bool DisableDefaultConstraintCheck {
    bool get ();
    void set (bool value);
}

[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.Deploy, 
    "false")>]
member DisableDefaultConstraintCheck : bool with get, set

function get DisableDefaultConstraintCheck () : boolean 
function set DisableDefaultConstraintCheck (value : boolean)

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

See Also

Reference

UserOptions Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Configuring SQL Server in SMO

NIB user options Option