title: SQL Drop View Statement Takes Forever to Complete
body: <p>I have a SQL Server 2008 R2 Enterprise database with a view on it called vw_Users.  </p>
  
  <p>-Running (Select * from vw_users) takes less than a second to complete.</p>
  
  <p>-Running the SQL inside of the view takes less than a second to complete.</p>
  
  <p>-Running (drop view vw_Users) just hangs and never actually completes.  I let it run for about 10 minutes before I cancelled it.</p>
  
  <p>I restarted the SQL Server Agent, then tried again, but it's still occurring. </p>
  
  <p>This is a brand new issue, this server and this database have been running fine for over a year.</p>
  
  <p>There are no indices on the view.  I'm not sure what the problem is, but any help would be very appreciated.</p>
  
  <p>Thanks</p>