A quote from this year JAOO conference in Århus 🙂
“Agile is like teenage sex – everyone talks about it, very few are actually doing it, and those who do usually don’t do it very well.”
James Coplien
October 2008
Not permitted to change tables in MS SQL server 2008?
When I started playing around with SQL server 2008, and tried to edit at table I just created, I often got an error sounding something like this:
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.
With the option to click cancel, or save the error messeage as a text file. Nice…!
Well, the error is self explaning, but it’s a pain that the default behavior of MSSQL Server 2008, doesn’t enable you to edit a table.
Anyway, I found the solution in books online.
Tools->Options->Designers->Table and Database Designers and clear the Prevent saving changes that require the table to be re-created.