Hello

I have a DB in SQL-Server 2000 and I want to make a trigger to delete rows in a table when a row in a realtioned table is deleted.

I attempt to do this using foreign key restrittions but in my case it isn't possible because it will create cicles.

I need the same behaviour as a foreign key but using trigger.

Please help me.