Bottom line: always specify whether you want to create a clustered or nonclustered primary key on the [font="Courier New"]add constraint PK_..[/font] statement.