I generally like using the IDE’s that Microsoft provide for developers. But in this case, I had an annoying problem. When creating my database model I always use Microsoft SQL Server Management Studio. As you all know, during development your tables often change a bit. You create new columns, delete old ones, change the type of a column, define new keys, etc.
In SQL Server 2005 SSMS I don’t remember doing one of the above actions resulted in an error. Now I’m using SQL Server 2008 SSMS and I repeatedly got the 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”.