posted on Thursday, March 18, 2004 2:23 PM by Enigma

Clustered Index frustrating me

SQL Server - Clustered Index frustrating me

create clustered index AOP_C_Idx on AOP_Master([Date])
Running this query gives the error :
Server: Msg 169, Level 15, State 2, Line 2
A column has been specified more than once in the order by list. Columns in the order by list must be unique.

However I do not have any other indexes on the table. The table has already been created an contains valid data. What could be the problem ???

Comments