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