Saving change is not permitted MS SQL 2008

Posted on May 4, 2009. Filed under: MS SQL | Tags: |

Been battling with MS SQL 2008 and ran across the issue (it’s actually a feature!) of not being able to save changes made to a table in designer view. I got the following error:

Saving change 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 cant be re-created or enabled the option Prevent Saving changes that require the table to be re-created.

Seems there is an easy fix (if you know where to look), go to
Tools Menu >
Options >
Designers >
And untick the option “Prevent saving changes that require a table re-creation”

Make a Comment

Make a Comment: ( 1 so far )

blockquote and a tags work here.

One Response to “Saving change is not permitted MS SQL 2008”

RSS Feed for Comments RSS Feed

Wow, thanx!


Where's The Comment Form?

Liked it here?
Why not try sites on the blogroll...