Notifications
Clear all

[Solved] Saving database changes is not permitted

 

Joined: 2 years ago
Posts: 2
Topic starter  

I want to change a database column in SSMS and get the following error message:

Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created. You have made changes to a table that can’t be re-created or enabled the option Prevent saving changes that require the tables to be re-created.

Quote
Joined: 7 years ago
Posts: 9
 

In order to make changes to a table, you have to change an option in SQL Server Management Studio (SSMS).

  • - In SSMS, in the main windows menu, choose Tools → Options… → Designers.
  • - Uncheck the option ”Prevent saving changes that require table re-creation

 

 

 

This post was modified 2 months ago 15 times by Prof. Dr. Peter Lehmann

ReplyQuote

Leave a reply

Author Name

Author Email

Title *

Maximum allowed file size is 10MB

Preview 0 Revisions Saved
Share: