Ran across a small issue with SQL Server 2008 Management Studio when attempting to add an identity column to a table which didn’t have one. As this action requires the entire table to be rebuilt (which Management Studio does behind-the-scenes), I was presented with an error message saying that ‘Saving changes is not permitted’.
By default in Management Studio 2008, you’re prevented from saving changes in the designer that require table re-creation. You can turn off this setting easily and the blog post at this link shows you how. :-)
SQL Server 2008 Designer Behavior Change: Saving Changes Not Permitted
Hopefully this might save you fifteen minutes one day.
