title: SQL Server 2008 Express (shared hosting) Times Out When Changing Data Type on Field
body: <p>I'm changing some bad design on a table. The field I'm trying to change holds IIS7 session id's which are long numbers. I'm trying to change the field from nvarchar(20) to int. There are 349,000 records in the table.</p>
  
  <p>SQL Server Management Studio times out after 35 seconds. However, if I check the query timeout setting for the connection it is set at 600 seconds (and I can't change it either).</p>
  
  <p>Is there another timeout setting that could be causing this problem?</p>
  
  <p>Here's the error message I'm getting:
  - Unable to modify table.<br>
  Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.</p>
  
  <p>I've been able to change several other tables with no problem. Of course, they had fewer rows.</p>
  
  <p>This database is on a shared hosting package at Arvixe.com. Do you think this could be part of the problem?</p>