Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Error in table (SQL 6.5)

Status
Not open for further replies.

guber

Programmer
Joined
Jan 4, 2002
Messages
27
Location
US
When I run any SQL Command like 'select * from table'
SQL Server returns this message...

Msg 602, Level 21, State 15
Could not find row in Sysindexes for dbid '6', object '55671246',index '1'.
Run DBCC CHECKTABLE on Sysindexes.
The SQL Server is terminating this process.

I already ran DBCC CHECKTABLE in sysindexes and nothing..

Someone have a idea ??
 
Try running DBCC CHECKTABLE on the table which equates to object '55671246'.

If this doesn't resolve your problem drop all your indexes on object '55671246' and then re-create and try again.

Rick.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top