One annoying new feature in SSMS is that when you make a change to a table using the Designer which requires the table to be re-created, such as creating an identity column, by default, you'll get the following message:
Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created. You have either made changes to a table that can't be re-created or enabled the option Prevent saving changes that require the table to be re-created.
To prevent this message from re-appearing, perform the following steps:
- In SSMS, click on Tools, then Options.
- Open up the Designers node.
- Click on "Table and Database Designers".
- Uncheck the checkbox labeled "Prevent saving changes that require table re-creation".
- Click on OK.
2 comments:
Thanx for the tip!!..
Thank you -- this is exactly what we were looking for! :-)
Post a Comment