how to configure connection pooling

Hi,
Is there a way to control the connection pools using SQL Server 2000? I
know how to alter the connection string to do
this(http://msdn.microsoft.com/library/d...ry/en-us/cpguid
e/html/ cpconconnectionpoolingforsqlservernetdat
aprovider.asp), but I am
looking for a setting in SQL Server that allows me ultimate control over all
connections to the DB. eg: I'd like all connection pools to timeout after
5min of inactivity, set the maximum pool size, etc. I am assuming that there
is some part of the GUI that allows this, or maybe even some (ugh) registry
editing! ;-)
Thanks,
LanceThis is all controlled on the client side. I'm not aware of anything that
can be configured within SQL Server itself that would affect this in the way
you want.
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Lance" <lancestuff27[nospam]@.hotmail.com> wrote in message
news:104bba8p9eo5333@.corp.supernews.com...
> Hi,
> Is there a way to control the connection pools using SQL Server 2000? I
> know how to alter the connection string to do
>
this(http://msdn.microsoft.com/library/d...ry/en-us/cpguid
> e/html/ cpconconnectionpoolingforsqlservernetdat
aprovider.asp), but I am
> looking for a setting in SQL Server that allows me ultimate control over
all
> connections to the DB. eg: I'd like all connection pools to timeout after
> 5min of inactivity, set the maximum pool size, etc. I am assuming that
there
> is some part of the GUI that allows this, or maybe even some (ugh)
registry
> editing! ;-)
> Thanks,
> Lance
>