97/09/05 15:30:10.76 spid18 Error : 602, Severity: 21, State: 15

Hi - I have been getting the following error message at the same place

in a long running process. This occurs after about 5 mins into the last

step. Both the step with the error and the prior step use explicitly

defined tempdb tables extensively. Once this error has occured a

re-run directly of this step are always successful.

97/09/05 15:30:10.76 spid18 Error : 602, Severity: 21, State: 15

97/09/05 15:30:10.76 spid18 Could not find row in Sysindexes for dbid

'2', object '190580458',index '1'. Run DBCC CHECKTABLE on Sysindexes.

The database for dbid 2 is tempdb. The following is a copy of the DBCC

checks of tempdb. Note that the left over tables in tempdb which

currently cause errors for the DBCC checkdb go away when SQL server is

cycled.

Thanks a lot for any help

DBCC checktable(Sysindexes) - on tempdb

Checking sysindexes

The total number of data pages in this table is 7.

Table has 43 data rows.

DBCC execution completed. If DBCC printed error messages, see your

System Administrator.

DBCC checkdb(tempdb)

Checking tempdb

Checking 1

The total number of data pages in this table is 4.

Table has 26 data rows.

Checking 2

The total number of data pages in this table is 7.

Table has 43 data rows.

Checking 3

The total number of data pages in this table is 27.

Table has 463 data rows.

Checking 4

The total number of data pages in this table is 1.

Table has 26 data rows.

Checking 5

The total number of data pages in this table is 1.

Checking 6

The total number of data pages in this table is 1.

Checking 7

The total number of data pages in this table is 1.

Table has 3 data rows.

Checking 8

The total number of data pages in this table is 1.

*** NOTICE: Notification of log space used/free cannot be reported

because the log segment is not on its own device.

Table has 27 data rows.

Checking 9

The total number of data pages in this table is 1.

Table has 18 data rows.

Checking 10

The total number of data pages in this table is 1.

Table has 3 data rows.

Checking 11

The total number of data pages in this table is 1.

Checking 12

The total number of data pages in this table is 1.

Checking 13

The total number of data pages in this table is 1.

Checking 14

The total number of data pages in this table is 1.

Checking 15

The total number of data pages in this table is 1.

Table has 1 data rows.

Checking 16

The total number of data pages in this table is 1.

Checking 17

The total number of data pages in this table is 1.

Checking 18

The total number of data pages in this table is 1.

Checking 94580116

Msg 2501, Level 16, State 2

Table named #Tmp_Applic_T001____02000000E8 not found; check Sysobjects

Checking 222580572

Msg 2501, Level 16, State 2

Table named #Tmp_Application____02000000E8 not found; check Sysobjects

Checking 1265328728

Msg 2501, Level 16, State 2

Table named #Tmp_Applic_T001____020000003A not found; check Sysobjects

Checking 1338805108

Msg 2501, Level 16, State 2

Table named #Tmp_Applic_T001____02000000C4 not found; check Sysobjects

Checking 1393329184

Msg 2501, Level 16, State 2

Table named #Tmp_Application____020000003A not found; check Sysobjects

Checking 1466805564

Msg 2501, Level 16, State 2

Table named #Tmp_Application____02000000C4 not found; check Sysobjects

Checking 1701093762

The total number of data pages in this table is 1.

Table has 9 data rows.

DBCC execution completed. If DBCC printed error messages, see your

System Administrator.