One new feature in SQL Server Management Studio 2008 (SSMS 2008) is the ability to restrict changes that would force a table to be re-created. This is a safety valve which can be turned off, if you choose. Let’s take a look…

For those who tested the new SQL Server 2008, you probably got this message, when trying to change the columns in some tables, add columns or change NULL conditions. "Save is not permitted"... and something like tables have to be dropped and re-created. The only choice you have is to click cancel, or to choose to save the message to a text file, which is, i think, not very useful. The solution i found today is in SQL Books Online, and it is pretty easy:

Tools -> Options -> Designers, and uncheck the option "Prevent saving changes that require table re-creation".

Why did MSFT add this ?  Enter the Table Designer, right-click on the table in question and choose “Design”.  Make a change.  Clicking the “Table Designer” menu item and select “Generate Change Script” to see the required T-SQL script required to make your change.  Yes, it drops all relationships, sends your data to a temp table, and makes the change.  If the table has many rows, you may want to find a more effective way due to the data copy.