Assertion and 823 errors!

Hi,
We have been getting a lot of 823 errors lately, ran
checkdb and it always comes out with 0 errors.
We ran a detailed disk and hardware diagnostic and could
not come up with any issues.
However, today, we got a failed assertion error :
SQL Server Assertion: File:
<R:\sql\ntdbms\storeng\drs\include\record.inl>, line=1447
Failed Assertion = 'm_SizeRec > 0 && m_SizeRec <= MAXDATAROW'.
I isolated this error to an application that is mostly UI
driven (with respect to performing Unions and joins),
since i read in MSKB that this may also be caused by any
subquery with a distinct clause or anything that returns a
row bigger than 8060KB.
I have 3 queries that run, and i checked the execution
plans, the tables are all properly indexed and they seem
to look fine.
we have EMC hardware , sql 2000 on Advanced server
(8.00.818)
Not sure what the next steps should be, Appreciate your
guidance and suggestions.
Thanks,Sounds like a case for MS Support to me (assuming you are up on service pack and have searched KB).
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"mark" <anonymous@.discussions.microsoft.com> wrote in message
news:02f701c3b449$acd3a670$a101280a@.phx.gbl...
> Hi,
> We have been getting a lot of 823 errors lately, ran
> checkdb and it always comes out with 0 errors.
> We ran a detailed disk and hardware diagnostic and could
> not come up with any issues.
> However, today, we got a failed assertion error :
> SQL Server Assertion: File:
> <R:\sql\ntdbms\storeng\drs\include\record.inl>, line=1447
> Failed Assertion = 'm_SizeRec > 0 && m_SizeRec <=> MAXDATAROW'.
> I isolated this error to an application that is mostly UI
> driven (with respect to performing Unions and joins),
> since i read in MSKB that this may also be caused by any
> subquery with a distinct clause or anything that returns a
> row bigger than 8060KB.
> I have 3 queries that run, and i checked the execution
> plans, the tables are all properly indexed and they seem
> to look fine.
> we have EMC hardware , sql 2000 on Advanced server
> (8.00.818)
> Not sure what the next steps should be, Appreciate your
> guidance and suggestions.
> Thanks,
>