**Update**

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.
ThanksReferential Integrity frist, then the After trigger.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--