Bernie Cook's Blog

Azure, C#, .NET, Architecture & Related Tech News


Saving Changes is Not Permitted – SQL Server

Whether you’re using SQL Server 2008 R2 Management Studio or SQL 2012 Management Studio you may come across this particular warning when attempting to commit changes to an existing table:

“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 recreated.” Continue reading