Saving changes is not permitted error message in SSMS

Updated: Oct 31, 2022

To change the Prevent saving changes that require the table re-creation option, follow these steps:

1. Open SQL Server Management Studio.

2. On the Tools menu, click Options.

3. In the navigation pane of the Options window, click Designers.

4. Select or clear the Prevent saving changes that require the table re-creation check box, and then click OK.

More info from Microsoft https://docs.microsoft.com/en-us/troubleshoot/sql/ssms/error-when-you-save-table

Recent Posts

See All

Setting Failure Alerts and Fail safe Operators on SQL Agent Jobs

What is database ownership ?

Snapshot Backups In SQL Server

In SQL Server, a snapshot backup is a type of backup that creates a read-only copy of a database at a specific point in time. Unlike traditional backups, which create a copy of the entire database, a

#1 - What Is SQL Server

#2 - SSMS

#3 - What Is SQL Server

#4 - What Is SQL

#5 - Editions Of SQL Server

#6 - Test Environment *

#7 - Intro To T-SQL

#8 - E.F Cod and 12 Rules

#9 - Data Types

#10 - Select Command

#11 - Update Command

#12 - Delete Command

#13 - Group By - Part 1

#14 - Group By - Part 2

#15 - Looping

#16 - Aliasing In T-SQL

#20 - Stored Procedures