Post reply

Select buffer is too small

  • February 23, 2009 at 1:36 pm

    #71866

    we are using sql server 2000. on one query, we got this error

    Select buffer is too small

    Reason: One of the application's sqlssb function calls set up a fetch buffer that is insufficient to hold the data that was fetched.

    Remedy: Determine which select buffer is too small and increase the size of that buffer. Checking the fetch status code for each column selected can help

    what is the fix for that? thanks

  • February 23, 2009 at 2:15 pm

    #948982

    shuzi (2/23/2009)

    we are using sql server 2000. on one query, we got this error...

    What were you using (client-wise) to execute this code? This appears to be a problem with the Client code, although it is being reported by the server.(?)

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.     [/font]    [font="Verdana"] "Performance is our middle name."[/font]

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

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