While trying to add new column in table which is already
created and trying to save table the following error may occur:
“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 enable the option prevent saving
changes that require the table to be re-created”
Error snapshot is given below:
Steps to solve error saving changes is not permitted in
MSSQL Server
Step 1: In Sql Server Management Studio click on Tools and
then select Options as shown in diagram:
Step 2: In the option window Select Designers in the left
side and in the right side under Table Options uncheck the option ‘Prevent
saving changes that require table re-creation ‘ and click on Ok button as shown
in the snapshot below:
After following all the steps given above again try to save your
table.
So nice and informative post you published with us . Much thanks for this post .
ReplyDelete