Gaurav,

Sounds to me like the table you're trying to reindex has two indexes
that use the same column or columns in its definition. Check the index
definitions to verify that they all use unique columns. If there is a
duplicate index definition, and both are needed, you will probably have
to rebuild each index individually.

S. Davey (6/29)


MI DIT\Agency Services
7:30 A.M. - 4:00 P.M. ET
517.335.4237 (M- F CCC )


>>> "Gaurav Kohli "
<mssqldba-ezmlmshield-x3756793.[Email address protected] 06/29/07 3:18
AM >>>
Hi Guys,

I get the error:

"A column has been specified more than once in the order by list.
Columns in the order by list must be unique."

When I run the query:

DBCC DBREINDEX(Table_Name,' ',90)

We are on SQL Server 2000

Any Ideas?

Thanks
Gaurav Kohli



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



MS Sql Server LazyDBA home page