title: SQL Server 2008 : Cannot Insert new column in the middle position and change data type
body: <p>My OS is Windows server 2008.</p>
  
  <p>I've already installed SQL Server Express 2008.</p>
  
  <p>I have several problems:</p>
  
  <ol>
  <li>I can't insert a new column in the middle position. If I insert in the last one, I can save the table design.</li>
  <li>I can change the column name but I can't change the data type.</li>
  </ol>
  
  <p>I got error message :
  Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created. You have either made changes to a table that can't be recreated or enabled the option Prevent saving changes that require the table to be re-created.</p>
  
  <p>Example:</p>
  
  <p>I have <code>ID, Name, Phone,</code> and <code>Status</code> columns. I am unable to add <code>Address</code> between <code>Name</code> and <code>Phone</code>.</p>
  
  <p>But, I can add <code>Address</code> if i place it after <code>Status</code>.</p>
  
  <p>Is there any way to solve this problem?</p>
  
  <p>Thanks before.</p>