title: Suppress transaction in stored procedure
body: <p>I want to know wether or not it is possible to suppress a transaction inside a SQL stored procedure. I have the following situation in my SP (that I want to achieve):</p>
  
  <pre><code>WHILE TRUE
  BEGIN TRY
      BEGIN TRANSACTION A
      RECEIVE MESSAGE FROM SSB QUEUE WITH TIMEOUT
  
      BEGIN SUPPRESS TRANSACTION 
        WHILE RECORD IN TABLE
           BEGIN TRANSACTION B
             DELETE RECORD FROM TABLE OUTPUT RECORD INTO D
             SEND RECORD D TO OTHER SSB QUEUE
           COMMIT TRANSACTION B
      END SUPPRESS TRANSACTION
      COMMIT TRANSACTION A
  END TRY
  BEGIN CATCH
      ROLLBACK TRANSACTION A
  END CATCH
  </code></pre>
  
  <p>so what I really want to do is that transaction B does not get enlisted in transaction A :)</p>