Solved

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

Posted on 2011-03-23
3
298 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 500 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

Why You Need a DevOps Toolchain

IT needs to deliver services with more agility and velocity. IT must roll out application features and innovations faster to keep up with customer demands, which is where a DevOps toolchain steps in. View the infographic to see why you need a DevOps toolchain.

Question has a verified solution.

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

This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
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…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

738 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