TR_EVENT_DELETE_BBNCEVENTIDMAP

                CREATE trigger TR_EVENT_DELETE_BBNCEVENTIDMAP on dbo.EVENT after delete not for replication
                as begin
                    delete from dbo.BBNCEVENTIDMAP
                        where EVENTID in (select ID from deleted)
                end