Error: 605, Severity: 21, State: 1

Environment:
SQL SERVER 2000 sp3 with security patch 818
Cluster environment: active-passive
HP running Windows 2003 with patches
Situation:
A stored procedure is running along with several other BCP
running.
I truned on DBCC TRACEON (818 -1)
I would like help with this error:
ERROR:
DATE/TIME: 10/1/2003 10:16:52 AM
DESCRIPTION: Error: 605, Severity: 21, State: 1
Attempt to fetch logical page (1:3360903) in
database 'WaveAggDetach' belongs to
object 'aggTradePlanVolume', not to
object 'aggTradePlanVolumeInvoiced'.
COMMENT: (None)
JOB RUN: (None)Does the database come out clean from a DBCC CHECKDB?
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"Katherine" <kphelps@.oceanspray.com> wrote in message news:01ee01c3883e$1675e1c0$a401280a@.phx.gbl...
> Environment:
> SQL SERVER 2000 sp3 with security patch 818
> Cluster environment: active-passive
> HP running Windows 2003 with patches
> Situation:
> A stored procedure is running along with several other BCP
> running.
> I truned on DBCC TRACEON (818 -1)
> I would like help with this error:
> ERROR:
> DATE/TIME: 10/1/2003 10:16:52 AM
> DESCRIPTION: Error: 605, Severity: 21, State: 1
> Attempt to fetch logical page (1:3360903) in
> database 'WaveAggDetach' belongs to
> object 'aggTradePlanVolume', not to
> object 'aggTradePlanVolumeInvoiced'.
> COMMENT: (None)
> JOB RUN: (None)
>
>|||Does the stored procedure contain a cursor..?
If so try changing the cursor type to INSESNSITIVE.
Have a look at :-
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q156662
--
HTH
Ryan Waight, MCDBA, MCSE
"Katherine" <kphelps@.oceanspray.com> wrote in message
news:01ee01c3883e$1675e1c0$a401280a@.phx.gbl...
> Environment:
> SQL SERVER 2000 sp3 with security patch 818
> Cluster environment: active-passive
> HP running Windows 2003 with patches
> Situation:
> A stored procedure is running along with several other BCP
> running.
> I truned on DBCC TRACEON (818 -1)
> I would like help with this error:
> ERROR:
> DATE/TIME: 10/1/2003 10:16:52 AM
> DESCRIPTION: Error: 605, Severity: 21, State: 1
> Attempt to fetch logical page (1:3360903) in
> database 'WaveAggDetach' belongs to
> object 'aggTradePlanVolume', not to
> object 'aggTradePlanVolumeInvoiced'.
> COMMENT: (None)
> JOB RUN: (None)
>
>