TR_CONSTITUENTINTEREST_TASYNC_I (Trigger)

        
    create trigger TR_CONSTITUENTINTEREST_TASYNC_I on dbo.CONSTITUENTINTEREST after insert not for replication
    as begin
      if dbo.UFN_B2T_CONTEXTISSYNC() = 0
      begin
        insert into dbo.TA_CONSTITUENTINTEREST (ID, SYNCID, ACTIONCODE)
        select ID, newid(), 1
        from INSERTED

        -- note that the above insert could fail if row is deleted and then reinserted w/ same ID before sync is run

        -- since we would not know anything about whether the row is really the same or not, we need to throw an exception

        -- to resolve, run the sync, then retry the insert

      end
    end