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 - 2001-11-26 : 09:34:45
|
| robert writes "I have MSSQL that came with a version of TimeSlips, the time and billing program. How can I easlily determine the maximum number of users that I can run through SQL7? Or, is that as long as I have licenceses for TimeSlips I would be ok?You help in answering this question is appreciated. Rob" |
|
|
SQLServerDBA_Dan
Aged Yak Warrior
752 Posts |
Posted - 2001-12-03 : 10:10:13
|
quote:
robert writes "I have MSSQL that came with a version of TimeSlips, the time and billing program. How can I easlily determine the maximum number of users that I can run through SQL7? Or, is that as long as I have licenceses for TimeSlips I would be ok?You help in answering this question is appreciated. Rob"
You can use SQL Server Query Analyzer and the following Transact-SQL statement to determine the maximum number of user connections that your system allows:SELECT @@MAX_CONNECTIONSSQL Server is limited to 32,767 user connections. I'd like to see the server that this was tested on  DanielSQL Server DBA |
 |
|
|
|
|
|
number of users