title: Varchar(255) to Varchar(MAX)
body: <p>Is it possible to change a column type in a SQL Server 2008 database from <code>varchar(255)</code> to <code>varchar(MAX)</code> without having to drop the table and recreate?</p>
  
  <p>SQL Server Management Studio throws me an error every time I try to do it using that - but to save myself a headache would be nice to know if I can change the type without having to DROP and CREATE.</p>
  
  <p>Thanks </p>