Tuesday, 14 June 2011

MSSQL Saving Change is not Permitted (Prevent)

This was a cheeky one I came across today. Where I was getting the following message from SQL Server 2008 in the table designer:
Saving change 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 cant be re-created or enabled the option Prevent Saving changes that require the table to be re-created.
The solution is to change the setting by using the menu: Tools > Options > Designers, then unchecking the "Prevent saving changes that require table re-creation" box.

 Guessing it's not a problem and more like a feature. Little bit odd, but I can understand why...

No comments:

Post a Comment