title: if DDL statement fails whole transaction is rolled back sql server
body: <p>I have a series of DML and DDL(Drop View only) statements that I need to execute under single transaction from VB.net app. I m using commandObj, and kept above all I kept beginTransaction statement. Everything is working fine expect when error is returned by Drop statement. If Drop statement returns error then whole transaction is rolledback. I do not want tthis. I want to continue even if Drop fails keeping the other DML statements that were executed before Drop. is this possible?</p>
  
  <p>thanks in advance <br>
  Sai</p>