Monday, September 14, 2009

Saving Changes is not permitted.The changes you have made require the following tables to be dropped and recreated..Sql Server 2008 Management Studio Express Error

If you have just installed Sql Server 2008 Express Edition and you have your default settings then you probably might get this error when your want to change some table and then save changes.

In the default settings “Prevent Saving changes that require table recreation” is checked which prevents to save the changes which you make in the design of the table.

So in this article i will talk less and give you a walkthrough on how to remove this ugly error and to keep it explanatory i will use images rather then simple text.

So the error looks like this

 

Now the stepwise solution is :-

  1. Click Cancel on this screen and then click OK on the next screen.
  2. On the top menu bar select the Tools option and inside tools select the Options menuitem.

 

 

  3.Inside options select the “Designer” and in the designer context form “uncheck” the option which says “Prevent Saving changes which requires recreation”.

  4.Click OK and you are done and now save changes to your table and your error should no vanish.

Happy Programming!!!!!!!!!!!!

1 comments :

Saurabh said...

yesterday i spent around 30 mins for the solution. really a grt help

Post a Comment