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/cpconconnectionpoolingforsqlservernetdataprovider. 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/cpconconnectionpoolingforsqlservernetdataprovider. 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