[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

How can I configure this to allow me to modify the table?

Posted on 2011-03-23
3
Medium Priority
?
309 Views
Last Modified: 2012-05-11
Hi, I want to add a PK and move this column position to the top of the table in design mode but I get the error as attached file.  How can I fix this?  Thanks.  I'm sql 2005 express with Adv features.  
err.txt
0
Comment
Question by:lapucca
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 19

Expert Comment

by:Bhavesh Shah
ID: 35204524
Hi,

Error is not coming properly.
Please re attach...
0
 
LVL 19

Accepted Solution

by:
Rikin Shah earned 2000 total points
ID: 35204537
Go to Tools > Options > Designers > Uncheck "Prevent saving changes that require table re-creation"

This problem occurs when the Prevent saving changes that require the table re-creation option is enabled, and you make one or more of the following changes to the table:

    * You change the Allow Nulls setting for a column.
    * You reorder columns in the table.
    * You change the column data type.
    * You add a new column.
0
 

Author Closing Comment

by:lapucca
ID: 35204558
That worked.  thank you.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):    . Check for publisher's certificate revocation    . Check for server ce…
Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …

649 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