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 - 2002-07-16 : 09:26:55
|
| Joanne writes "Can I use trigger to check for the referential integrity? I've tried but the system message always pop up and not my trigger message. May I know how to do this?" |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2002-07-16 : 10:18:44
|
| SQL Server uses after-triggers, meaning, the trigger fires after the completion of the dml. If your DML violates some FK constraint, your trigger will never fire. If you are on SQL 2K, you can look at INSTEAD OF triggers. Otherwise, you need to manage referential integrity in your DML.<O> |
 |
|
|
|
|
|
useTrigger in Referential Integrity check?