SQL 2000 SP3a running on W2K Server SP4. Access 97 front end. Back end was
ported from Access. I get the following two errors several times a day.
Searched in the KB and the only article (827714) that comes close doesn't
seem to address my problem. Unless the hotfix it mentions is the answer...
SQL Server Assertion: File: <recbase.cpp>, line=1378
Failed Assertion = 'm_offBeginVar < m_SizeRec'.
SQL Server Assertion: File: < p:\sql\ntdbms\storeng\drs\include\record
.inl>,
line=1447
Failed Assertion = 'm_SizeRec > 0 && m_SizeRec <= MAXDATAROW'.
Has anyone else seen these problems? It is always a query - I've never seen
it on a statement.Hi Ron,
I am not sure what Service Pack level you are on or if you are running into
the same situation as mentioned in the symptom section of article 827714.
Normally you would see this type of assertion when you have corruption in a
database. As a starting point I would like you to run DBCC CHECKDB on your
database. Make sure that you have no corruption in the database by making
sure that DBCC CHECKB shows "0" allocation and "0" consistency errors.
If you do find corruption in the database, restore it from a good backup.
Hope that helps !!!
Thanks,
Fargham Butt
Microsoft - SQL Server
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment