Filed under
This is more of a note to myself. Every time I reinstall SQL 2008 and want to make a table change, I am faced with this error:
Nice warning, but please, just let me make changes to my tables. I'm trying to develop here. Now I understand this is good for a production environment in case you are making a quick change to a table (I would use RedGate's tools myself though).
To fix this, in SSMS, go into the Tools menu, choose Options. Then click on Designers in the treevier. Uncheck "Prevent saving changes that require table re-creation". There you have it.
Again, I have forgotten about this setting a dozen times. Hope it helps someone.
a2985e5b-467a-4c52-9e8f-e938a0d2097b|0|.0