create a primary key Index after store column index

Question

When I create a primary key Index on table which already has store column index , It display syntax error 

Although I create the primary key from SSMS , Design a table , Set Primary key , Then Save , 

I did not write any code and the error message is syntax error !!

---

khaled Mohamed

Answer 1

Can you please post you the complete error message?

---

Olaf Helper
* cogito ergo sum * errare humanum est * quote erat demonstrandum *
Wenn ich denke, ist das ein Fehler und das beweise ich täglich
Blog Xing

Answer 2

It seems to work ok in both designer and TSQL in CU2 (11.0.2325). Which version version are you using. Can you post a sample table create script that is failing?

If you try it in TSQL you may get a better error message.

E.g.

alter table mytable add constraint PK_Col1 primary key clustered (Col1);