title: Sql Server Management Studio: table locked due to select statement
body: <p>Given the following scenario:
  A select statement is executed from Sql Server Management Studio (2005, 2008) to retrieve a large resultset. This is <strong>not</strong> done by choosing 'Edit top 200 rows' from the context menu.</p>
  
  <p>Our DBA says that it's possible this can lock the table being queried. Unlocking occurs when the query results are closed.</p>
  
  <p>I can't find any documentation that confirms this is true. 
  So, fact or fiction?</p>
  
  <p><strong>Edit:</strong><br>
  Selected Aaron's answer, and thumbs up to Yuri and Lloyd for helpful answers.</p>
  
  <p>Regards,</p>
  
  <p>Michel</p>