Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-05-03 : 13:08:18
|
| GY writes "erver: Msg 169, Level 15, State 2, Line 2A column has been specified more than once in the order by list. Columns in the order by list must be unique.Server: Msg 169, Level 15, State 1, Line 2A column has been specified more than once in the order by list. Columns in the order by list must be unique.Server: Msg 169, Level 15, State 1, Line 2A column has been specified more than once in the order by list. Columns in the order by list must be unique.Server: Msg 169, Level 15, State 1, Line 2A column has been specified more than once in the order by list. Columns in the order by list must be unique.Server: Msg 169, Level 15, State 1, Line 2A column has been specified more than once in the order by list. Columns in the order by list must be unique.DBCC execution completed. If DBCC printed error messages, contact your system administrator.The initial problem is a query running very very long time and I found that if i removed one condition from the WHERE clause, it can display the result instantly.I try to add an index to that field, but stop respondingI try to DBCC DBREINDEX, but got the above error. PLEASE HELP" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-05-03 : 13:14:44
|
| Could you post the query?Tara |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-05-03 : 21:47:02
|
| Looks lke you have a corrupt index definition or something.Try it on each table individually then each index until you find the culprit.Then try dropping the index and recreating.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
|
|
DBCC DBREINDEX (joborder, '', 80) ERROR. Please help