Claus on Code

A data dudes random musings about code, bugs, products, life etc.

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.

Posted by:

Claus

One response to “Not permitted to change tables in MS SQL server 2008?”

  1. Lefkada Villas Avatar
    Lefkada Villas

    I do love the way you have presented this specific difficulty and it does indeed provide me some fodder for thought. Nonetheless, through what I have experienced, I simply just hope when the actual comments pack on that men and women continue to be on issue and not embark on a tirade involving some other news of the day. Yet, thank you for this exceptional point and whilst I do not agree with it in totality, I value your viewpoint.

Leave a Reply

Your email address will not be published. Required fields are marked *