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.
+4
A:
In SQL Server 2008, go to Tools >> Options. In the little window, click "Designer". Uncheck "Prevent saving changes that require ..."
Marcos Buarque
2009-01-20 05:21:04
I already found the answer but thanks for the help.
Middletone
2009-01-20 06:36:54