I did a sp_helpindex on some of me SQL 7 tables
the results I got for the primary key are "nonclustered, unique, primary key located on PRIMARY"
and there are many tables with primary keys but they are not clustered .
How is this possible?
How can we change it to be Clustered. ?