TR_EDUCATIONALHISTORYSTATUS_CHECKSYSTEMENTRIES (Trigger)

                
                    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