At one point there was a topic with this subject that I posted on
05-Oct-2005.

I have refined the criteria to reproduce the problem that I have
observed.  This problem appears to be an ODBC problem.  I have posted a
new message within microsoft.public.sqlserver.odbc under the topic
"Stored procedure does not complete until result set is retrieved from
ODBC" on 11-Nov-2005.

Consecutive values
Random number generation with seed value
Compute sum of count(*) with group by
Copying records from one table to another
Automate Importing File