Microsoft cloud engineer - SharePoint, Office 365, Azure, DotNet, Angular, JavaScript.
Microsoft cloud engineer - SharePoint, Office 365, Azure, DotNet, Angular, JavaScript.

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

© Copyright 2016
@ SPJeff

Return to Top ▲Return to Top ▲