Re: 'with check option' constraint

From: Tony Rogerson <>
Date: Tue, 22 Nov 2005 09:29:03 -0000
Message-ID: <dluo34$s7a$1$>

you could probably do something with an instead of trigger, depends what you are doing.

Tony Rogerson
SQL Server MVP - free video tutorials

"Carl Federl" <> wrote in message

> Oracle, Ocelot, and SQL Anywhere support defering check constraints
> until commit.
> Definitely not supported by DB2 or MS SQL Server.
> MS SQL Server does allow disabling a constraint, but the disabling
> applies to all connections and is not automatically re-enabled on
> commit.
Received on Tue Nov 22 2005 - 10:29:03 CET

Original text of this message