SQL Server – Management Studio Unable to save changes
f you are using management studio and attempt to add a column to a table or some other activity and get a message telling you that you will need to recreate a table, don’t worry. The message is not clear. What it is trying to say in the message is that data in the table maybe deleted if you add a column to the table. Management studio has a setting that causes this message. I recommend turning this option off. It can be found in the following location. Tools-> Options-> Designers-> Table and Database Designers-> Uncheck the option. “Prevent saving changes that require table recreation”