PRINT statement output to screen

  • Is there a way to force a "flush" of the print buffer to the screen when using a PRINT statement inside a stored proc? If I create an SQL script with PRINT statements, they are output almost in real-time, but if I use a stored proc with PRINT statments, they are only flushed to the screen every so often.

    -Dan


    -Dan

  • Turn ON In QA - Options - Results :

    1) Scroll results as received (*)

    Specify that the results should be scrolled as they are returned.

    Edited by - tcartwright on 01/07/2003 10:25:01 AM


    Tim C //Will code for food

  • Thanks for the reply. The problem is that there is nothing coming back to scroll. The server has not yet sent the results from the PRINT statement to the QA. I'm wondering if there is a trick, like padding the PRINT statement out to 4096 characters (packet size)?

    -Dan


    -Dan

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

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