Admin-Ahead Community

Windows => General Windows => Topic started by: dustin on August 11, 2014, 07:08:34 am

Title: Unable to save changes that require recreation of database
Post by: dustin on August 11, 2014, 07:08:34 am

Getting the following error in SQL server 2008 while making changes to a table structure that requires the table to be recreated

"Saving changes is not permitted.Changes you have made require tables to dropped and re-created."

To fix this,
Go to Tools -> Options -> Designers -> Tables and Designers and uncheck the Prevent Saving Changes that require table re-creation option.

====