Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-03-06 : 08:37:02
|
| Anil writes "How to restrict the connection to limit number in sql server?" |
|
|
efelito
Constraint Violating Yak Guru
478 Posts |
Posted - 2002-03-06 : 15:18:10
|
| In EM, right click on server. Select properties. Click on Connections tab. Change the number in the Maximum concurrent user connections box. Click OK and restart the SQL Server Service.In QA, run the following command. sp_configure 'user connections', <number of connections>Then run reconfigure. Then restart the SQL Server Service.Jeff BanschbachConsultant, MCDBA |
 |
|
|
|
|
|
Sql Server Connection