TR_RESPONSE_T2BDELETE

CREATE trigger [TR_RESPONSE_T2BDELETE] on dbo.[RESPONSE] after delete not for replication
as 
  begin
    -- TAIntegration data sync

    if dbo.[UFN_B2T_CONTEXTISSYNC]() = 1
      update dbo.[B2TROWS] set 
        [SYNCSTATUSCODE] = 11
      where [BBECID] in (select [ID] from deleted)
      and [BBECTABLE] = 'RESPONSE';
    end