Article ID: 99813
Article Last Modified on 2/14/2005
APPLIES TO
- Microsoft SQL Server 4.21a Standard Edition
- Microsoft SQL Server 6.0 Standard Edition
- Microsoft SQL Server 6.5 Standard Edition
This article was previously published under Q99813
SUMMARY
If there are duplicate rows in the table, the query
CREATE CLUSTERED INDEX index_name ON table_name WITH SORTED_DATA
will fail and the following error message will appear:
Some users may want to use allow_dup_row combined with sorted_data options to workaround this problem. However, it will still fail with the same error message.
To work around this problem, use the following query:
CREATE CLUSTERED INDEX index_name ON table_name WITH ALLOW_DUP_ROW
MORE INFORMATION
The description for SORTED_DATA in the "Language Reference" manual includes the following:
It verifies that the data has indeed been sorted by checking each index value to see if it is higher than the previous one.
Additional query words: create clustered index
Keywords: kbinfo kbprogramming KB99813