SQL Server Management Studio – Error message when you try to save a table in SQL Server: “Saving changes is not permitted”.

This problem occurs when “Prevent saving changes that require table re-creation” option is enabled.

Solution:

Go into Tools -> Options -> Designers-> Uncheck “Prevent saving changes that require table re-creation”.

Leave a Reply

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