Prevent saving changes that require the table to be re-created.

You are modifying a table, using Design table in SSMS, and want to generate a change script (or maybe you want to save your change)

Table Designer → Generate Change Script

Sql Server Management Studio (SSMS) produces this error:

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

Oh no!

To enable this option, go to:

Tools → Options → Designers → Table and Database Designers → Table Options

Prevent saving changes that require table re-creation

results matching ""

    No results matching ""