While trying to modify the table, I got a peculiar message box in SQL Server 2008. It's allowing me to change the property of a table or any object. Searching in MSDN, I have end up with the exact solution to resolve this issue. Below is the solution,
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