![]() |
---|
CREATE trigger dbo.TR_EDUCATIONALHISTORYSTATUS_CHECKSYSTEMENTRIES on dbo.EDUCATIONALHISTORYSTATUS after delete not for replication as begin if (exists (select ID from deleted where ID in ('00000000-0000-0000-0000-000000000001', '00000000-0000-0000-0000-000000000002', '00000000-0000-0000-0000-000000000003', '00000000-0000-0000-0000-000000000004'))) begin raiserror('System educational history status entries cannot be deleted.',13,1); end end |