Post reply

Internal error. Buffer provided to read... while execute SQL-Statement

  • July 15, 2009 at 6:52 am

    #206981

    Hello,

    i think i need some help with our SQL-Server 2008. Unfortunetaly i did not find any working solutions in the web. Maybe i find here some help, because it is really needed. 🙂

    Situation:

    I get the following Error Meesage when i try to execute a simple SQL-Statement:

    Message 682....

    Internal error. Buffer provided to read column value is too small. Run DBCC CHECKDB to check for any corruption.

    Here is the SQL-Statement i tried tu use:

    select * from TABLE where FILED in (select FIELD from TABLE where FIELD = 'VALUE')

    DBCC does not note any error. I know that there has been a similar issue with the SQL-Server 2005. MS fixed that with a Hotfix. But till now there is none for 2008 version.

    Thanks

    Dirk

  • January 3, 2010 at 9:16 pm

    #1098276

    try to rebuild the indexes on 'where clause' related column ...

  • March 1, 2011 at 3:17 pm

    #1293254

    I'm getting the same error and have it narrowed it down to an update statement. It's running on 2008 and updating via a linked server (2000), and if there are multiple rows to be updated it kicks out the error. If there's one row to be updated, it works fine. This same process (update via linked server to 2000) works fine when ran on 2005. SQL 2008 is at 10.0.4.4000, and linked server (2000) is at 8.0.2055. It uses a temp table and I have changed it to use a permanent table and same error occurs. Multiple inserts to the linked server work fine. Any help would be appreciated.

  • October 2, 2023 at 4:50 am

    This was removed by the editor as SPAM

Viewing 4 posts - 1 through 3 (of 3 total)

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