title: How to use a single SqlTransaction for multiple SqlConnections in .NET?
body: <ol>
  <li>I have SQL Server 2000, <strong>it doesn't support MultipleActiveResults</strong>.</li>
  <li>I have to do multiple inserts, and it's done with one connection per insertion.</li>
  <li>I want to begin a transaction before all insertions and finish it after all insertions.</li>
  <li>How do I do it?</li>
  </ol>