Posted by kwdavids on 01/30/06 20:26

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.

[Back to original message]