Does anyone have any opinions on enforcing Referential Integrity in SQL Server 2000 with Triggers vice Relationships ...

BOL points in the direction of Relationships and that seems to work well with Codebook ... XCase 7.0 uses Triggers to enforce RI ... which also seems to work as well.

As with any consultant type of answer I'm sure it starts with "It depends"; however, I would like to hear some arguments in each direction ... what are the strengths/weaknesses of each approach?

Thanks,

Charles T. Blankenship