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

3 Comments

  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.

    Jayanthi

  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.

comment_type == "trackback" || $comment->comment_type == "pingback" || ereg("", $comment->comment_content) || ereg("", $comment->comment_content)) { ?>

Trackbacks & Pingbacks

  1. Harry

    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. comment_type == "trackback" || $comment->comment_type == "pingback" || ereg("", $comment->comment_content) || ereg("", $comment->comment_content)) { ?>

    Trackbacks & Pingbacks

    1. Jeyanthi

      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.

      Jayanthi

    2. comment_type == "trackback" || $comment->comment_type == "pingback" || ereg("", $comment->comment_content) || ereg("", $comment->comment_content)) { ?>

      Trackbacks & Pingbacks

      1. Kevin

        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