Microsoft KB Archive/99813

= INF: Create Clustered Index with SORTED_DATA Option =

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:

Create index aborted on duplicate rows.

(Msg 1508, Level 16, State 1)

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 &quot;Language Reference&quot; 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

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.