December 6, 2010 at 9:56 am
How many user connections a sql server 2000 edition can have at a time?
I know the maximum concurrent connections setting and its set to 0 which means unlimited, is there any other setting that can prevent the new connections or terminate an existing connection?
Where can i see/set the connection pooling settings?
December 6, 2010 at 11:11 am
Connection pooling isn't handled by the database engine, it's handled by a higher level of code.
The upper limit on connections, if you set it to 0, is 32,767, per http://msdn.microsoft.com/en-us/library/ms143432.aspx.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply