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


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