BorlandTalk.com

Sarah · Guest

What is the significance of a "State: " number in an error message in SQL Server 2000?

I am using SQL Server 2000 Standard edition,
and I am seeing the below error message hundreds of times
if I profile a database for a few minutes:

Error: 602, Severity: 21, State: 16

I found the below link that *exactly* matches the above error, including the state code:
http://support.microsoft.com/kb/279793/EN-US/
But Microsoft claims they fixed that issue a long time ago.

If I search sysmessages table for the 602 error with
select * from master..sysmessages where error = 602

I get the below results:
<ColumnName = Value>,

error = 602,
Severity = 21,
dlevel = 0,
description = Could not find row in sysindexes for database ID %d, object ID %ld, index ID %d. Run DBCC CHECKTABLE on sysindexes.,
msglangid = 1033

Is that dlevel is nothing but *State*?

Since my sysmessages table does not contain that state#16,
should I assume this is an unexpected bug?
Or should I simply treat it as a problem with indexes?
Btw, reindexing the database every night is not helping to fix this.

I am going crazy with this error, and with all it's ambiguity.
Any help will be highly appreciated

Thanks,
Sarah

Sarah · Guest

Okay, Microsoft uses these State IDs to know
which part of their code was going panic at the time of an exception:
http://msdn.microsoft.com/library/?url=/library/en-us/acdata/ac_8_con_05_6zw8.asp?frame=true

If I pay them $250.00 per each support call,
they would throw some light on that part of the code and let us know what to do.

Thanks,
Sarah

Oliver Townshend · Guest