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 |
|
pgiancola
Starting Member
3 Posts |
 Posted - 2001-04-16 : 23:06:54
|
| Our server crashed and now I am getting this error when ever I try to access one table of the database...[Microsoft][ODBC SQL Server Driver][SQL Server]Scan on sysindexes for database ID 10, object ID 2009058193, returned a duplicate index ID 3. Run DBCC CHECKTABLE on sysindexes.I ran DBCC CHECKTABLE and got these results...Table error: Object ID 2, Index ID 0. Duplicate keys on page (1:162) slot 2 and page (1:162) slot 3.To be honest, I am new enough to SQL Server to not know how to fix this.Does anyone have any suggestions? Any help would be appreciated.Paul GiancolaEdited by - pgiancola on 04/16/2001 23:26:21 |
|
|
|
|
|
Duplicate Index....how do I fix