title: How to change a column without dropping a table in SQL 2008
body: <p>Why does SQL 2008 all of a sudden want to drop my tables when I go to change the column type from say int to real?  This never happened in SQL 2005 to my knowledge.  Any insight would be helpful please.</p>