Can't save table design changes in SQL Server 2008

The default settings in SQL Server 2008 do not allow you to modify and save the design of a table if it requires that table be dropped and recreated. Instead, you'll get a nice error message that looks like this



This is nice if you don't want to accidentally change the design of a table, but I have a feeling most people that are in the SQL Management Studio application are using it for just that. The good news is this is easy to fix and only requires you to change one thing.

Within SQL Management Studio, go to Tools->Options->Designers->Table and Database Designers, then uncheck the box that says "Prevent saving changes that require table re-creation" and click OK. That's it, now you can change the design of your SQL table(s) and save them.

Thanks to vinodummy.com for pointing me in the right direction