Microsoft® SQL Server® 2008 R2 Service Pack 1 to fix it via following link: Microsoft® SQL Server® 2008 R2 Service Pack 1 Reference:  http://stackoverflow.com/questions/552458/why-is-sql-se

If you get the following error message when you re-design the table and couldn't save it: Saving changes is not permitted. The change you have made requires the following table to be dropped and

SET ROWCOUNT 1 DELETE FROM [TableName] WHERE [ConditionColum] = ‘conditionValue’( and .....)