Post reply

Invalid text, ntext, or image pointer value

  • April 7, 2004 at 9:22 am

    #359411

    When running update text statement, Im having trouble tracking down why I get the following error;

    Server: Msg 7123, Level 16, State 1, Line 52 Invalid text, ntext, or image pointer value 0xFFFF2FA1B4000000DCC4080001001200.

    The statement has been terminated.

    I ran dbcc check db, check table and TEXTVALID with no errors.  I created a second table and copied a smaller set of data to it (400,00 rowes) and it worked. I created a copy of the production table and it failed as well. Any ideas on what I can run to fix it or discover the problem?

     

     

     

    Thank you.
    Francis S. Mazeika
    MS SQL DBA
    609-707-5207
    francis.mazeika@gmail.com

  • April 8, 2004 at 2:57 am

    #502101

    Not sure if this is related, but I had a similar problem some time ago. It turned out to have something to do with truncating the table containing the text field - apparently this can mess up the pointers.

    Seems consistent with the fact that copying the data to a new table solves the problem.

    I guess the workaround is to use DELETE, not TRUNCATE

    Regards

    Rob

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply