July 9, 2004 at 2:17 am
Hi folks,
I hope someone can help me out there. I have a server running Win2000 Server latest SP. SQL 2000 SP3a. I am running an update/Insert query but receive the following error:
Location: recbase.cpp:1378
Expression: m_offBeginVar < m_SizeRec
SPID: 54
Process ID: 1096
I Have tried a Hotfix supposed to fix the problem but it keeps occurring - Anyone have any ideas
Thanks
Ado
July 9, 2004 at 11:13 am
There are two KB articles regarding this issue:
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q317852
http://support.microsoft.com/?kbid=827714
The first one suggests to install SP3 (which you installed already), the second suggests a post-SP3 hotfix (build 8.00.0857 or later). You can download build 8.00.0878 from:
http://support.microsoft.com/?kbid=838166
What version do you have now ? (Run SELECT @@VERSION to find out).
In what circumstances do you encounter the problem ? If the first KB article is closer, then it's possible that the table is already corrupt; installing the latest version will not repair the table (it will only prevent corruption to other tables). In this case, I suggest that you copy the data to a temporary table, re-create the corrupted table and copy the data back into it.
Razvan
PS. I did not encounter this problem myself, my advices are based only on reading the KB-s.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply