SuperSKa Weblog » Unable to save changes to a table (SQL2008)
MSMVPS.COM
The Ultimate Destination for Blogs by Current and Former Microsoft Most Valuable Professionals.

Unable to save changes to a table (SQL2008)

Don't you love it when you have just a tiny task and get surprised by something you never heard of? I don't but still it happens...

So, I need to add a column to a table in my local SQL2008 database. Open up SQL Server Management Studio, navigate to the table, right click, choose Design Table, add the column and click the diskette icon (how long will that still be around?). Easy as that, except that I get punched in the face by this message:

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.

Never heard of that. I'm pretty sure the table can be dropped and re-created, so I'll start off searching for the option "Prevent saving changes that require the table to be re-created".

But I DO love it when you find an option you're looking for at first try. Tools, Options, Designers, Table and Database designers:

image

Posted Tue, Mar 3 2009 11:50 by Stefan Kamphuis
Filed under: , ,

Questions? Contact Susan at Susan-at-msmvps.com. Each post's copyright held by the original author. All rights reserved. Blog site is an independent site not sponsored by Microsoft.
Our servers would like to thank www.ownwebnow.com and www.exchangedefender.com. We wouldn't be here without the generosity of Vlad Mazek and his companies.

Powered by Community Server (Commercial Edition), by Telligent Systems
biz:andrewbelon.com