TR_EVENT_DELETE_BBNCEVENTIDMAP (Trigger)

                
                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