Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
A bad day
Message
From
11/05/1998 18:52:36
 
 
To
11/05/1998 16:40:16
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
Miscellaneous
Thread ID:
00098570
Message ID:
00098618
Views:
32
>SQL Server reports this:
>
>Could not find row in Sysindexes for dbid '7', object '880006166',index '0'. Run DBCC CHECKTABLE on Sysindexes.
>
>I tried reindexing, checking size, etc. But, I still have this message. Any idea on how to fix it? Thanks.

Michael,

An indid of 0 is reserved for a table that does not have a clustered index. I've got no idea how it could of happen and no idea how to fix it (how's that for honesty <bg>.)

Can you recreate the table? Can you create a clustered index? If so, create the index and then drop it. Hopefully that will recreate the indid 0 row in sysindexes.

-Mike
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform