SQL Server administration and T-SQL development, Web Programming with ASP.NET, HTML5 and Javascript, Windows Phone 8 app development, SAP Smartforms and ABAP Programming, Windows 7, Visual Studio and MS Office software
Development resources, articles, tutorials, code samples, tools and downloads for ASP.Net, SQL Server, Reporting Services, T-SQL, Windows, AWS, SAP HANA and ABAP


SQL Server Management Studio 2008 SSMS : "Saving changes is not permitted" error


Using Microsoft SQL Server Management Studio (SSMS) that comes with MS SQL Server 2008 R2 version, I created a few sql tables.
Later I decided to change the nullable properties of some sql table columns.

saving-changes-is-not-permitted

After I configured the Allow Nulls property of the table columns by clearing or marking the check box, I clicked on the Save button to update my changes to the database schema, I got the following sql exception displayed on the SSMS IDE.

changes-you-have-made-require-the-following-tables-to-be-dropped

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.





Actually this sql warning is a customized IDE property that warns and reminds that the desired schema change requires table drop and re-create.
In order to disable this SQL Server Management Studio warning, SQL Server database administrators and sql developers can follow the below steps:

Using the SSMS top menu, open Tools menu and select Options sub-menu item. (Tools > Options)

ssms-tools-options

On the Options screen, click on the Designers node on the left treeview structure.

prevent-saving-changes-that-require-table-re-creation

You can see the option Prevent saving changes that require table re-creation which is checked and activated by default.
Please uncheck and clear this option.

uncheck-option-prevent-saving-changes-that-require-table-re-creation

After this SQL Server Management Studio (SSMS) Designers option configuration, sql developers and SQL DBA 's can alter table structures more easily without facing Saving changes is not permitted. error message.



SQL Server

SQL Server 2019 Installation
download SQL Server 2019
download SQL Server 2017
download SQL Server 2016
download SQL Server 2014
download SQL Server 2012
MacOS ve SQL Server 2019


Copyright © 2004 - 2021 Eralper YILMAZ. All rights reserved.