Skip to main content

Windows Server 2012 SQL Server Management Studio Error: Saving changes is not permitted [SOLVED]

Have you encountered an error while making changes to your Database tables that says:

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.
Figure 1




The error message is giving us clues on how to solve this with the last statement "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."

Based on my experience, the problem is that the "Prevent saving changes that require table re-creation" is checked. (Look at the figure below..

Figure 2

In order for you to save these kind of changes, you have to uncheck it by going to Tools>Options..

Figure 3




Then look for "Designers" at the left and click on the "Table and Database Designers" (Refer to Figure 3 below)

Figure 4
The "Prevent saving changes that require table re-creation" should now in unchecked mode like the photo above.

Refresh you SQL Server Management Studio and the error should now cease to exist when you save changes in your tables.

Comments

Popular posts from this blog

Reaction Paper for the movie The Count of Monte Cristo

The Second Part of the Reaction Paper on the Count of Monte Cristo Movie. The Count of Monte Cristo is a great story that helps you to realize how far the reaches of vengeance can really go. When the Count is going around ruining people it seems like he is more of a machine than a person. It seems like he has no emotions and can’t forgive the people who hurt him. Although some people might argue that the people who wronged the Count truly had what was coming to them, some of the Count’s actions could be seen as unnecessary. In the end everyone will be punished or rewarded by God and you shouldn’t be worried about what other people do or say as much as you are worried about yourself. “God will give me justice,” this line which was engraved in the wall on the prison was retained on my mind when I watched the movie” The Count of Monte Cristo.” This movie amazed me very much because of its excellent theme. I really like the story because it has a mixed of drama, suspense and rom

PROVEN and TESTED: Step-by-step guide to Register Alumni Association with SEC Philippines

Registering and Incorporating your High School or College Alumni Association with the Securities and Exchanges Commission (SEC) is a straightforward process now especially that SEC already have an online process. Here is how we registered our Non-stock and non-profit alumni organization with the SEC in less than a month process. Prepare the personal information of your incorporators Before going to the SEC website, you will the the following information of your incorporators prepared: Complete name such as their first name, middle name, last name Birth date Address, and  TIN number Use the SEC eSPARC Online Company Registration Go to the SEC website and look for the Online Services and select SEC eSPARC and click on the Regular Processing. Alumni associations are non stock corporation so you won't be able to avail of the OneSEC Processing. Remember the following important step: Select the nearest SEC office from your area, you will need to bring the signed and printed copy later o

Guide on How to Buy Train Ticket at the Ticket Vending Machine of Philippine MRT and LRT [with photos]

Traveling via train is still one of the most convenient and efficient way of wandering around places especially in huge cities and provinces like Manila if you don't have your own private cars and thus opted to commute. Currently there are four lines of rapid transit systems continuously operating in Metro Manila such as the MRT Line 3 which runs along EDSA from Taft Avenue in Pasay City to North Avenue in Quezon City, the LRT Line 1 which runs from Baclaran Station of Paranaque City to Roosevelt Station in Quezon City, the LRT Line 2 runs from CM Recto in Santa Cruz Manila to Santolan Station in Marikina City, and the PNR Train which used to be the longest train system in the Philippines but stopped operations of most of its routes.  Map of LRT and MRT Trains in Metro Manila as of 2015. From Wikimedia Although buying tickets is still like lining up to catch a box office number one hit movie during rush-hours, you can still conveniently ride trains in the Philippin