title: SqlCommand.ExecuteNonQuery locks the table
body: <p>I am using a C# winform application and I have this code using SQl server:</p>
  
  <pre><code>SqlCommand comm;
  comm.CommandText = "alter table anyTable add someColumn int null";
  comm.ExecuteNonQuery();
  </code></pre>
  
  <p>when I debug this code section, right after the     comm.ExecuteNonQuery();, I want to go to SQL server management and do a "select * " on the relevant table to check on the changes.</p>
  
  <p>Problem is that I can't touch this table, the SQL server "Executing query" for a long time and it wont do it until the connection will be refreshed, but I can accsess another tables.</p>
  
  <p>This problem does not always exists and I cant figure out why it happens.</p>
  
  <p>Thank you for your help!!!</p>