Jaa


UserOptions.DisableDefaultConstraintCheck Property

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
Public Property DisableDefaultConstraintCheck As Boolean
public bool DisableDefaultConstraintCheck { get; set; }
public:
property bool DisableDefaultConstraintCheck {
    bool get ();
    void set (bool value);
}
/** @property */
public boolean get_DisableDefaultConstraintCheck ()

/** @property */
public void set_DisableDefaultConstraintCheck (boolean value)
public function get DisableDefaultConstraintCheck () : boolean

public function set DisableDefaultConstraintCheck (value : boolean)

Property Value

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 Microsoft SQL Server 2005.

This namespace, class, or member is supported only in version 2.0 of the Microsoft .NET Framework.

Example

How to: Modify SQL Server Settings in Visual Basic .NET

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Platforms

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

See Also

Reference

UserOptions Class
UserOptions Members
Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Configuring SQL Server in SMO
user options Option