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
- You are trying to add a new column in middle of the table.
- Dropping or deleting the column from the table
- Trying to change the data type in the table
- Trying to change the Order of the Column
How to Solve
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.
On a development server you can uncheck this option but for the production server keep sure you check this option.
Select Table and Database Designers
Uncheck Prevent saving changes that require the table to be re-created
You need to use the ROLLBACK Transaction
Hope this solution works in your case and if not feel free to comment and get in touch with us to solve your problem.