FIXED – SQL Saving changes is not permitted

Wanted to share quick fix for SQL Server Management Studio (SSMS) when updating table schema design.  Cheers.  shades_smile

Error

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

Fix

  1. Launch SQL Management Studio
  2. Clink menu “Tools > Options
  3. Expand menu “Designers” and uncheck box “Prevent saving changes that require table re-creation.”


Screenshots

image

image

Return to Top ▲Return to Top ▲