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

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
lapuccaAsked:
Who is Participating?
 
Rikin ShahConnect With a Mentor Microsoft Dynamics CRM ConsultantCommented:
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
 
Bhavesh ShahLead AnalysistCommented:
Hi,

Error is not coming properly.
Please re attach...
0
 
lapuccaAuthor Commented:
That worked.  thank you.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.