Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining


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

Important noteImportant

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.

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).

Community Additions

© 2015 Microsoft