Use profiler.<br><br>SQL leaves them open for a time for the connection pooling of course. -- View image here: http://episteme.arstechnica.com/infopop/emoticons/icon ...

It seems kind of sily that you just can't up the number of max connections, or buy more, without resorting to server. <P>Server has a completely different "mentality," tools, abilities, purpose, etc ...