title: Convert Column from Date to Datetime
body: <p>I have a column named <code>Lastmodified</code>, with a data type of <code>Date</code>, but it should have been <code>DateTime</code>.</p>
  
  <p>Is there any way of converting the column?</p>
  
  <p>When I use the 'Design' feature of SQL Server Management Studio I get the following error:</p>
  
  <blockquote>
    <p>Saving changes is not permitted. The changes you have made require the following 
    table to be dropped and re-created.</p>
  </blockquote>
  
  <p>Not really interested in dropping the table, I just want to know if it is possible to convert a column from <code>Date</code> to <code>Datetime</code> or do I have to delete the column and create a new one with the correct data type?</p>