title: Changing the data type without dropping the table in sql server 2008
body: <p>I can change the datatype in sql server 2005 but why cannot in sql server 2008. Everytime if i want to change my datatype i need to drop the table and create again..any alternate solution for this problem? </p>