SSMS Tip: Disable "Saving Changes is Not Permitted" Warning

If you've ever experienced the dreaded Saving changes is not permitted dialog in SQL Management Studio, this tip is for you.


To disable the message, open the Tools -> Options menu and navigate to Designers -> Table and Database Designers:


From there uncheck the Prevent saving changes that require table re-creation checkbox. Hit the OK button and you'll be all set.

While this change might not be recommended if you're in a production environment, it's great to get rid of this block when you're developing and designing your databases.