title: Is it possible to ALTER TABLE (DDL) in the middle of an DML transaction on the same table?
body: <p>Say, you begin a SqlTransaction from C# inside which you are inserting data from a DataTable into a SQL table, but this data is A LOT of data, so you do it 'in chunks' with a SqlBulkCopy inside the SQL transaction and only commit the transaction if ALL the chunks copied succesfully. </p>
  
  <p>Now, let's say you know that at times the length of the values being inserted will surpass the max column size in the target table, so the SqlBulkCopy will fail at that point for that particular 'chunk'. Is it possible (or even advisable) to catch this exception and alter the table/column to increase the max length of the target column, then continue SqlBulkCopy'ing data picking up the next 'chunk' to be copied even though you haven't committed your 'insert transaction' you began with?</p>
  
  <p>So, trying to paraphrase this, is it possible to start a DML transaction, stop in the middle of this uncommitted transaction, perform a DDL to alter the target table, then complete the original DML and commit it?</p>