Monday, May 17, 2010
Saving changes is not permitted. How to save the changes in table design, column ordering in SQL Server 2005 / 2008
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 requires the table to be re-created.
While designing database or during initial development mode I keep changing the database schema (sometimes adding more fields or re-arranging the column positions) I got this popup many times and that makes me to go and write alter script to do the changes in table schema but through alter script I dont know how to change the column position so at last I have to fix this popup and do my changes easily through table designer.
Below are few steps to fix this popup and it will never appear
Step1: in SSMS, go to Tools>>Options…
Step 2: Drill down to Designers >> Table and Database Designers
Step 3: You will see bunch of check boxes there is one which is highlighted in above screen shot "Prevent saving changes that requires table re-creation" uncheck this check box,
Hit OK, that's all you are done, now go to your table designer and add columns, rearrange column position now it will not prompt any popup.