Geeks With Blogs

News Opinions and articles on this blog are mine alone and do not represent my employer. All articles and blog entries are posted using a personal computer system outside of my employer network.
Sam Abraham Software Engineer/Architect: Putting Customers First
With most of our systems pre-configured with SQL server, it was only today that I ran into this issue with my fresh installation instance of SQL Server 2008 R2.
 
I had just created a new SandBox DB to experiment with some aspects of Entity Framework 4.0, but as I was saving foreign key changes to tables I had already created I got the following error:
 
Saving Changes is not permitted. The changes you made require the following tables to be dropped and re-created
Figure 1 - Unable to save table schema changes error
 
With some research, I found my answer in SQL Books Online: Any Schema changes made to a table would require disabling the default option of “Prevent saving changes that require the table to be re-created”. To resolve this, from SQL Management Studio, go to: Tools->Options->Designers->Table and Database Designers. We would then need to uncheck the “Prevent saving changes that require the table to be re-created” check box as shown below and Voila!
 
Prevent Saving Changes that require table re-creation
Figure 2- Uncheck The "Prevent saving changes that require table re-creation" check box
Posted on Thursday, October 7, 2010 12:27 PM Fladotnet.com , Tech Talk , SQL Server | Back to top


Comments on this post: All in a Day’s Work: SQL Schema Save Failure: The Save Not Permitted Dialog Box

No comments posted yet.
Your comment:
 (will show your gravatar)


Copyright © Sam Abraham | Powered by: GeeksWithBlogs.net