SQL Server 20XX : Unable to modify table…

After 3+ years of not touching SQL Server, I managed to get my hands on SQL Server 2012.  After creating two tables, and deciding to modify the first table schema, I get my first error message….

“Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created….yada..yada…yada.”

So, sound coding methodologies suggest we analyze the change properly, and use caution while doing this. However, if you are starting off with a new project, there is always an option in the tools menu.

Tools > Options > Designers > Uncheck “Prevent saving changes that require table re-creation

image

Leave a Reply