title: Sql server drop table not working
body: <p>I have a table with almost 45 million rows. I was updating a field of it with the query:</p>
  
  <pre><code>update tableName set columnX = Right(columnX, 10)
  </code></pre>
  
  <p>I didn't do tran or commit but directly ran the query. During the execution of query, after an hour unfortunately power failure occurred and now when i try to run select query it takes too much time and returns nothing. Even drop table doesn't work. I don't know what is the problem. </p>