Recbase.CPP Problem

  • 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

  • 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