William Duffy

Glasgow Based C# ASP.NET Web Developer

Sql Server 2008 – Saving changes is not permitted

After installing Sql Server 2008 one of my developers was having a hard time trying to save updates to any of our database tables. Every time he tried to save a table alteration he was presented with 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.

The error is helpful enough in telling us clearly what the problem is, and how to fix it – (or enabled the option Prevent saving changes that require the table to be re-created). However, in true Microsoft form we need to hunt down the option ourself.

To make life easier here is where the option resides.
Tools > Options > Designers

Once there you will see the following checkbox option
Prevent saving changes that require table re-creation

Uncheck this and click OK. Simples!

Tagged as + Categorized as SQL Server


  1. As ever, not got a clue what you’re on aboot with this kinda stuff WD, but…”simples”!!!

    That meerkat is just the best! I LOVE that dude!

  2. Thanks a lot.
    You have very simply given the solution for which I was exploring all server options and database properties and table properties for hours together.


  3. thanks for sharing that knowledge William. I was rumbling about in the database | table options looking for a property that was at a higher level.

Leave a Reply