Error Message box content:
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.

SQL Server 2008 holds a new validation to stop the changes happened on a table.
To remove the option,
Goto Tools -> Options->Designers -> Tables and Database designers.
Uncheck the option, prevent saving changes that required table re-creation.

:-) It's an error occured in my table. Resolved the error by myself(Suspense). Am able to edit the table now.

Cheers,
Venkatesan Prabu .J
No comments:
Post a Comment