Home Dashboard Directory Help
Search

Changing a Primary Key on a table in Design View by vs2010junkie


Status: 

Closed
 as By Design Help for as By Design


1
0
Sign in
to vote
Type: Bug
ID: 323951
Opened: 1/24/2008 7:47:50 AM
Access Restriction: Public
0
Workaround(s)
view
0
User(s) can reproduce this bug

Description

When changing a Primary Key in Design view using SQL Server 2008 November CTP, you receive an error message that the changes cannot be saved.
Details
Sign in to post a comment.
Posted by Microsoft on 1/24/2008 at 9:51 AM
Hi,

Thank you for reporting the problem. The message shown is due to the default option in SSMS.

If your change requires a Table Drop / Recreate and you would like to proceed with this option, please enable the same by doing the following:

* Go to Tools-> Options
* Click on Designers
* Uncheck the 'Prevent saving changes that require table recreation'

Thanks
Karthik
Sign in to post a workaround.