This is an annoying message that is prompted when trying to make changes to a table in SQL Server 2008/Express. While there can be many valid reasons for having this option [Prevent saving changes] switched on by default you would prefer to have this switched off during the implementation phase of the project.
Steps to disable the option [Prevent saving changes]
- Click on the Tools menu
- Click on Options of the Management Studio
- Click on the “Designers” tree
- Click on “Table and Database Designers”
- Uncheck “Prevent saving changes that require table-creation”
- Click “Ok”

No comments:
Post a Comment