Posted by Hugo Kornelis on 01/31/06 00:16

On 30 Jan 2006 10:26:25 -0800, kwdavids wrote:

>For what it's worth...
>
>It turns out that I had set up two "firehose" DataSets on the same
>connection. This resulted in the 2nd connection being opened and closed
>thousands of times by ADO. In my situation, SQL Server is going out to
>lunch after about 6,000 connections.
>
>Putting the second query on another connection has stopped the multiple
>connections and SQL server locks up no more.

Hi kwdavids,

Thanks for reporting back the cause of the delays. And I'm glad to hear
that you've got this figured out!

--
Hugo Kornelis, SQL Server MVP

[Back to original message]