Solved

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

Posted on 2010-08-18
2
773 Views
Last Modified: 2012-05-10
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
Comment
Question by:wlwestrom
2 Comments
 
LVL 2

Expert Comment

by:uscshaggy
ID: 33467620
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
 
LVL 42

Accepted Solution

by:
dqmq earned 500 total points
ID: 33467627
Either make the changes using DDL from a New Query window or disable the option (see screenshot).


PreventSavingChanges-3.bmp
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now