how to configure connection pooling

[Lance]

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/de...y/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

[Jasper Smith]

This 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:10*************@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/de...y/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