Sql Express 2008 - saving changes

Recently I installed SQL Express 2008 on my home machine and on my first outing with it I received this error

Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created. You have either made changes to a table that can't be re-created or enabled the option Prevent saving changes that require the table to be re-created.

It turns out that the ability to edit a table that will result in the table being recreated in SQL Server Express 2008 is turned off by default. Awesome!!!

To enable this you need to go the the menu
Tools --> Options --> Designers
and then Table and Database Designers. Uncheck the checkbox marked "Prevent saving changes that require table re-creation"




Problem solved!