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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Missing Indexes

Author  Topic 

Onamuji
Aged Yak Warrior

504 Posts

Posted - 2001-10-05 : 10:38:02
For some reason this morning the SQL server decided to forget or add imaginery indexes on a table.

Has anyone run into this issue before? I fixed the issue by adding the indexes and removing them, some how, somewhere one of the sys tables got messed up but I couldn't find which one. Anyhow it's fixed but the question is, has this happen to any of you before?

Mainly I need to know because if it has I need to find and eliminate the problem.

- Onamuji

"One day I'll be better than nr"
   

- Advertisement -