TR_SPROPPNOTETYPECODE_DELETE_SYSTEMROLEPERMCODETABLEENTRY

create trigger TR_SPROPPNOTETYPECODE_DELETE_SYSTEMROLEPERMCODETABLEENTRY on dbo.SPROPPNOTETYPECODE after delete not for replication as begin delete from dbo.SYSTEMROLEPERM_CODETABLEENTRY where CODETABLECATALOGID = '4ca73726-4511-496b-8a2b-fa44999832f2' and CODETABLEENTRYID in (select ID from deleted) end