TR_IDSETREGISTER_DELETE_BBNCIDSETIDMAP

                create trigger TR_IDSETREGISTER_DELETE_BBNCIDSETIDMAP on dbo.IDSETREGISTER after delete not for replication
                as begin
                    delete from dbo.BBNCIDSETIDMAP 
                        where IDSETREGISTERID in (select ID from deleted)
                end