Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-06-23 : 10:35:24
|
| John writes "Does SQL Server 2000 have the ability to defer constraint checking to transaction commit time?Oracle and Postgres seems to with the SQL 92 standard statement:SET CONSTRAINTS { ALL | constraint [, ...] } { DEFERRED | IMMEDIATE }I found in books online some older reference to:DISABLE_DEF_CNST_CHK Controls interim or deferred constraint checking.but it says that was only for v6.5 and no longer does anything.I've got an order of update issue that this would really help with.Thanks!" |
|
|
|
|
|
Defer constraint checking to transaction commit?