SET DISABLE_DEF_CNST_CHK (Transact-SQL)

Specifies interim deferred violation checking and is used for efficiency purposes in Microsoft SQL Server version 6.x.

Important

This feature will be removed in the next version of Microsoft SQL Server. Do not use this feature in new development work, and modify applications that currently use this feature as soon as possible.

Remarks

If the compatibility level is set to 60 or 65, executing this statement does nothing. However, if the compatibility level is set to 70, executing this statement does nothing, and SQL Server returns a warning message. For more information about setting compatibility levels, see sp_dbcmptlevel (Transact-SQL).

See Also

Reference

CREATE TABLE (Transact-SQL)
DELETE (Transact-SQL)
INSERT (Transact-SQL)
SET (Transact-SQL)
UPDATE (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance