A union of curiosity and data science

Knowledgebase and brain dump of a database engineer

SQL SERVER MSSMS Error "Saving Changes is not Permitted."


   To fix this error in SSMS: At the top right of your studio go to Tools > Options.
Click on Designers and uncheck "Prevent Saving Changes that require table re-creation".
FYI, you should understand the implications of dropping and recreating your tables and this isn't always the best option for making table alterations.