SQL Server 2008 message box - Unable to edit the table property

 
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
Ebook Download
View all
SQL Jobs
Read by 0 people
Download Now!
Learn
View all