Hi

I'm working with SQL2000, and I defined the below structure:
MasterTable(No numeric(3),desc char(40)) No is PK
DetailTable(No numeric(3),code numeric(4),other char(40)) No&Code are PK
and I defined an Update Cascade for their relation.and I have an update 
trigger on MasterTable.

My question:
when I update the MasterTable, which one occures first(the casecade 
action,or update trigger on that)?
I would be grateful if somebody could give me a hint.

Thanks

Referential Integrity frist, then the After trigger.

HTH, Jens Suessmeyer.

---
http://www.sqlserver2005.de
---

Referential Integrity - Countries & States/Provinces
temporary view
understanding what trigger is doing
Could not create an instance of OLE DB provider 'Microsoft.Jet.OLE
Delete 'Non-Unique' Rows Question (with DDL)