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

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

Danggawan Elementary School Graduation 2016 | Speech of Jeffry Manhulad as a Guest Speaker

Sa atong mga tinahod nga bisita nga ania karong buntaga, ang akong pagtahod kaninyo, sa atong mga bootang maestro og maestra, mga opisyales sa barangay og sa atong katilingban, maayong bontag. Sa atong mga ginikanan, ang akong pagsaludo kaninyong tanan. Og usab, sa walay pabor-pabor, sa atong mga estudyante, kining panahona para kini kaninyo. Magsadya kamo kay sa pila katuig nga kamo nagbalik-balik dinhi sa tunghaan aron kamo makalampos, sa katapusan, pwede na kamo musinggit karon "Of all my sleepless nights, thank you Lord! At last, I am graduation!" Sa sulod sa pila ka tuig maka-ambak na gayud kamo sa sunod nga ang-ang paingon sa inyong paglambo. Ako nasayod nga inyo kining gipangandoy nga panahon, nga kamo mupaso sa entablado isip usa sa mga graduates dinhi karon. Dugay na kini ninyong gipangandoy uban sa inyong pamilya og sa mga tawong pirme nagasuporta kaninyo. Congratulations! Ani-a na kamo dinhi karon! Kita man siguro tanan adunay pan...

How to pay Cebu Pacific Booking using BDO Online Banking

For those of you who doesn't have a credit card but has BDO accounts and is registered to BDO Online banking at https://online.bdo.com.ph , it would be easier for you to pay your bookings at Cebu Pacific website because CEBU PACIFIC AIR does not require enrollment in BDO online banking anymore. Below is the detailed documentation on how I paid my Cebu Pacific Booking using BDO ATM that is registered to BDO Online Banking. The first thing to do is to make it sure that you have selected the fifth tab in where the BDO payment choice is listed. Look at the photo above. 1. Login to BDO Online Banking at https://online.bdo.com.ph 2. Click on The "Pay Bills" icon located at the left under "My Quick Links". See FIGURE 1 below. FIGURE 1 (Screen Grab from BDO Online Banking) 3. If you have multiple accounts registered on your BDO Online banking, select account where you pay from by clicking on the drop-down. (See FIGURE 2 # ...

Jeff Man

Search This Blog