Saving Changes Is Not Permitted SQL Server

Whenever you create a Table in SQL Serer and after saving you try to edit the table like as changing the type of column, adding more column, deleting you often come to this error “Saving changes is not permitted SQL Server

Saving changes is not permitted. The change you have made requires the following table to be dropped and re-created.

Know why this error appear

Possible Reason Of Saving Changes is not Permitted SQL Server

  1. You are trying to add a new column in middle of the table.
  2. Dropping or deleting the column from the table
  3. Trying to change the data type in the table
  4. Trying to change the Order of the Column

How to Solve

Solution

Go to the tools section -> Click Options -> Designer -> Table and Database Designers ->

Select or clear Prevent saving changes that require the table to be re-created

But for safety measure do not clear the options.

Saving changes is not permitted SQL Server"

On a development server you can uncheck this option but for the production server keep sure you check this option.

How do I save changes in SQL?

Select Designers
Select Table and Database Designers
Uncheck Prevent saving changes that require the table to be re-created

Can I roll back A query?

You need to use the ROLLBACK Transaction

Conclusion

Hope this solution works in your case and if not feel free to comment and get in touch with us to solve your problem.

Leave a Comment

Your email address will not be published. Required fields are marked *