RE: SQL Server Q?

[Adrian Roe]

Title: OT: SQL Server Q?

sp configure 'user connections'

 

This is an advanced option (believe it or not), so you may have to do "sp configure 'show advanced options', 1" before you do "sp configure 'user connections'". Alternatively you can just run SELECT @@MAX CONNECTIONS

 

Returns something like this....

name                                minimum     maximum     config value run value  
----------------------------------- ----------- ----------- ------------ -----------
user connections                    0           32767       0            0

Run value is what's configured at present. To change "sp configure 'user connections', 1000" (or whatever)

 

You will need to stop/start the database to make the change take affect.

 

Ade

 

-----Original Message-----
From: Jack van Zanen [mailto:[EMAIL PROTECTED]
Sent: 20 June 2003 13:45
To: Multiple recipients of list ORACLE-L
Subject: OT: SQL Server Q?

Hi All

I'm mainly into Oracle but in a SQLserver database we encountered this error

"maximum number of DBPROCESSes already exist"

In oracle I would look at the processes parameter but what would I be looking at in SQL server???

TIA

Jacob A. van Zanen

------------------------------------------------------------------------------
Live Life in Broadband
www.telewest.co.uk


The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material.
Statements and opinions expressed in this e-mail may not represent those of the company. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender immediately and delete the material from any computer.


==============================================================================