>>I think Neil may have posted this link before but read this through:
>>
http://msdn.microsoft.com/en-us/library/8xx3tyca.aspx>>
>>The connection string values that affect pooling are:
>>Connection Lifetime
>>Enlist
>>Max Pool Size
>>Min Pool Size
>>Pooling
>
>Thanks, this is good to know.
>
>>The last one dictates whether ADO.NET uses pooling. If you are not explicitly setting it to 'false' in your connection string then pooling is enabled and used.
>
>No, I do not have anything which would bypass the default.
>
>>Can you monitor the open connection count on the server?
>
>Is there specific tools we need to use for that or this can be verified as is from SSMS or something like that?
Maybe this:http://msdn.microsoft.com/en-us/library/ms175518.aspx (but SQL-Server is *not* my specialist subject :-} )