you could probably do something with an instead of trigger, depends what you
are doing.
--
Tony Rogerson
SQL Server MVP
http://sqlserverfaq.com - free video tutorials
"Carl Federl" <cfederl_at_yahoo.com> wrote in message
news:1132610415.581490.122750_at_g44g2000cwa.googlegroups.com...
> 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 - 03:29:03 CST
