Copy Code Trigger Definition

        
          create trigger TR_DONORCHALLENGEMEDIALINK_T2BDELETE on dbo.DONORCHALLENGEMEDIALINK 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 = 'DONORCHALLENGEMEDIALINK'
          end