Thursday, February 17, 2011

Saving Changes Not Permitted. Common Problem in SQL SSMS & Solution

While using SQL Server Management Studio (SSMS) for altering design of tables, we often see the below crappy window saying that, your changes can not be saved.


This happens because the changes that you have done require associated tables to be re-created. And by default this re-creation options is turned off the SSMS.

These same changes you can do using SQL commands without any complaint & that’s the reason I (and many of you) love to do things using SQL commands rather than using SSMS. Regardless, for the SSSMS lovers snapshot below shows the option which helps you out in such scenario.

Go to Tools > Options in SSMS and make sure that highlighted option is unchecked. That’s it and you can do whatever changes you want to do to the table schema using SSMS.

I hope some of you might find this post useful.
Cheers,