SQL Server – Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created.

Published on September 6, 2016 by abundantcode

Filed under SQL Server

Last modified September 6, 2016

Print this page

rate 1 star rate 2 star rate 3 star rate 4 star rate 5 star
Your rating: none, Average: 0 (0 votes)

This article have been viewed 2741 times

There are times when you get an error stating

"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."

You can easily resolve this issue by following the steps mentioned

1. Launch SQL Management Studio and connect to your SQL Server instance.

2. Navigate to Tools -> Options.

SNAGHTMLb53df3

3. In the Options dialog , select Designers in the left sidebar and then uncheck the option "Prevent saving changes that require table re-creation" and click ok.

image

This should solve the above issue.

Leave a Comment


x

You might be Interested in these Posts

C Program to find the G.C.D of a number using Recursive function

Problem Write a program in C to find the find the G.C.D of a number using recursion and display the ...

C Program to print a Half Pyramid using *

Problem Write a program in C to print Half pyramid using * as shown. * * * * * * * * * * ...

C Program to display Positive factors of a number

Problem Write a program in C to display all the positive factors of a number enter by the user. Ho...