• Actually - having just thought about it - I am wondering if it executes it using SET FMTONLY ON.

    If I use the following:

    SET FMTONLY ON

    GO

    EXEC stproc_test

    Then it immediately returns with the result set, in the correct shape. So I am guessing that's what you would want to do. Hope that helps. 🙂

    Atlantis Interactive - SQL Server Tools
    My blog[/url]
    Why I wrote a sql query analyzer clone