sorry - newbie question. migrating my db design from oracle SQL Server 7 so
i'm trying to replace all my cascade delete foreign key definitions with
cascade delete triggers. i can create my trigger fine:
CREATE TRIGGER space.sitefiles_delete ON space.files
FROM space.sitefiles, deleted
WHERE space.sitefiles.fileid = deleted.fileid
but it never seems to fire. i get a foreign key constraint error when i try
to delete a referenced record:
DELETE statement conflicted with COLUMN REFERENCE constraint .....
i don't think my trigger is firing at all. what am i missing - please help!