MS SQL: Saving changes is not premitted if the table need to be re-created
This is a classic. Microsoft SQL Server 2008 introduced a feature that prevents you from changing a table in the designer if it need to be re-created. And whenever i get this i always forget where to turn this feature off. This time i recorded a 14 sec video that shows where this option is. Enjoy :)