SQL Server 2008: Saving Changes Not Permitted

Are you getting the dreaded error on SQL Server 2008?: 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. This is a brain-dead design on Microsoft's part when all the permissions are there, and the database administrator laboriously made all the table changes, the save feature will fail. To fix this, UN-CHECK the Prevent flag under Options -> Designers in SQL Server Management Studio. Viewed 1540 Times Date Blogged: 5/14/2009