Posted by Erland Sommarskog on 05/27/05 00:30

Do Park via SQLMonster.com (forum@nospam.SQLMonster.com) writes:
> A software that connects SQL Server via ODBC uses 12 process at the same
> time when I look at the process info(panel). Is it possible to increase
> number of process (or thread) for a specific database? Is there any
> parameter?

You can change the number of permitted connections with

sp_configure 'user connections', 100 -- 100 is an example here

This is a server-wide setting. There is no per-database setting for this
(and neither would it be really meaningful).

However, the default for this option is 0, which means that the server
configures as it goes on.

Are you getting any error messages about running out of connections?

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

[Back to original message]