Sql Server 2008 - Saving changes is not permitted
After installing Sql Server 2008 one of my developers was having a hard time trying to save updates to any of our database tables. Every time he tried to save a table alteration he was presented with the error.
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.
The error is helpful enough in telling us clearly what the problem is, and how to fix it - (or enabled the option Prevent saving changes that require the table to be re-created). However, in true Microsoft form we need to hunt down the option ourself.
To make life easier here is where the option resides.
Tools > Options > Designers
Once there you will see the following checkbox option
Prevent saving changes that require table re-creation
Uncheck this and click OK. Simples!
Tagged as SQL Server + Categorized as SQL Server
As ever, not got a clue what you’re on aboot with this kinda stuff WD, but…”simples”!!!
That meerkat is just the best! I LOVE that dude!
Thanks a lot.
You have very simply given the solution for which I was exploring all server options and database properties and table properties for hours together.
Jayanthi
thanks for sharing that knowledge William. I was rumbling about in the database | table options looking for a property that was at a higher level.