USP_SKIPSEARCHCONSTITUENTUPDATES

      create procedure dbo.USP_SKIPSEARCHCONSTITUENTUPDATES as
      begin
        -- Context_info is referenced by triggers that do maintenance on SEARCHCONSTITUENT.

        -- If it is set to this value, the maintenance is skipped.

        -- The expectation is that the process calling this procedure will perform the maintenance in bulk later.

        set CONTEXT_INFO 0xE2DF375A033A104382689B8EAC5165AD;
      end