• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 802
  • Last Modified:

How do I disable option that prevents me from saving changes that require the table to be re-created

I upsized an access 2007 db to mssql 2008 with data coming over as well.  I am trying to add a key field and change various parameters and i cannot because i get a box that says: "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.

How do i solve this problem?  I am using MSSQL server management console.

thanks
0
wlwestrom
Asked:
wlwestrom
1 Solution
 
uscshaggyCommented:
To change this option, on the Tools menu, click Options, expand Designers, and then click Table and Database Designers. Select or clear the Prevent saving changes that require the table to be re-created check box.
0
 
dqmqCommented:
Either make the changes using DDL from a New Query window or disable the option (see screenshot).


PreventSavingChanges-3.bmp
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now