I’ve been using SQL Server 2008 for a month or two, and until recently, I got really irritated as I was unable to re-design some tables I found wasn’t performing the way I want it to. (I’m still trying to learn database designing to improve efficiency!) The solution is below.
Saving changes is not permitted. The changed 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.
Tools -> Options -> Untick “Prevent saving changes that require table re-creation” and you will be able to save changes!
I learnt one thing about myself. I’m often time too lazy to read the whole paragraph of the error message. The part I highlighted in bold actually taught me how to fix the problem, but I ignored it. I only found out when I was typing the whole error message out. I must change this aspect of myself, else I’m going to waste time googling for solutions.