TR_TEAMFUNDRAISER_DELETE_BBNCTEAMFUNDRAISERIDMAP

                CREATE trigger TR_TEAMFUNDRAISER_DELETE_BBNCTEAMFUNDRAISERIDMAP on dbo.TEAMFUNDRAISER after delete not for replication
                as begin
                    delete from dbo.BBNCTEAMFUNDRAISERIDMAP
                        where TEAMFUNDRAISERID in (select ID from deleted)
                end