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 Development (2000)
 Could not find row in Sysindexes

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-01-26 : 12:42:26
Doug writes "MS SQL 6.5 Sp5a, I am inserting records into a temp table by executing a SP with variables (@site_key,@start_date and @end_date). I am receiving the following error with certain parameters:
Msg 602, Level 21, State 4
Could not find row in Sysindexes for dbid '2', object '1374627940',index '-1'. Run DBCC CHECKTABLE on Sysindexes.
The SQL Server is terminating this process.

The object ID in the error msg is never the same each time I run the script.

I ran DBCC CHECKTABLE and DBCC Checkdb and get no problems.

If I change the Variable @site_key I do not receive an error."
   

- Advertisement -