SQL Server Management Studio (SSMS) is the powerful tool for any developer/DBA to intereact with the SQL Server. It has lot of features that many people do not aware of. In this series of blog posts I am going to show you some features which are very helpful and not known by many people.
While modifying the structure of the table in SSMS, you might have had the problem which resulted to the following error message
Save changes is not permitted. The changes you have made require the following tables to be dropped or re-created. You have either made the changes to a table that can't be re-created or enabled the option Prevent saving chages that require the table to be re-created.
To avoid this error follow these steps, in the toolbar, goto
Tools-->Options-->Designers-->Table and Database designers
and uncheck the option labelled Prevent saving changes that require the table to be re-created
Now you will be able to make changes in the table design in SSMS
Tags: t-sql, sql_server, sqlserver, tsql, BRH, SSMS, savechanges,
Nice! Good one to Share with Beginners. Did encounter this issue when i first started
Nice one, i never came across this.
I recommend disabling this on a test/development server only, once you are done with the development then enable it again. This is checked off to preserve the data integrity of the tables.