SQL Server will default to a Clustered index for PK constraints unless a Clustered index already exists on the table.

-Mike

>I am having a problem creating a PK constraint on an existing table. It seems as though whenever I create a PK constraint, SQL Server wants to make it a clustered index. From the BOL, I thought I could do this:
>
>ALTER TABLE Exchange
> ADD CONSTRAINT PK_ExchangeID PRIMARY KEY (ExchangeID) NONCLUSTERED
>
>But SQL Server won't let me do this. It always wants to make it a CLUSTERED index. Any ideas?