I’ve been away from database side for a while but these days I am designing one. And I had a strange error while working in SQL Server Management Studio 2008. I made some changes and while trying to same the diagram I was shown this message:
“Saving changes is not permitted. The change 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 enable the option Prevent saving changes that require the table to be re-created.”
While message explains the issue well I couldn’t spot this option right away. So here is it: Tools->Options->Designers
Uncheck the box and that’s all..:
Hope this helps.