Hi,
Is there any limit on number of connection on Sql Express 2008.
If yes then how many?

Thanks

Not really. The number of connections the server can managed is around
32,000 IIRC (if not more) but you'll exhaust the server's ability to service
that many connections long before you reach the limit. SQL Express places no
limit on the number of connections--just on the amount of system resources
that can be applied to the threads they start. Most heavily used servers
(ASP.NET architectures) typically service no more than a couple dozen
connections at a time. However, this is not to say that only 24 users can
connect--it means that at any point in time there are only a couple dozen
clients actually doing work.

What's your concern?

--
__________________________________________________ ________________________
William R. Vaughn
President and Founder Beta V Corporation
Author, Mentor, Dad, Grandpa
Microsoft MVP
(425) 556-9205 (Pacific time)
Hitchhiker’s Guide to Visual Studio and SQL Server (7th Edition)
http://betav.com http://betav.com/blog/billva
__________________________________________________ __________________________________________



"Piyush Trivedi" <trivedi.piyush (AT) noemail (DOT) noemail> wrote