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 |
|
Hyukevain
Yak Posting Veteran
66 Posts |
 Posted - 2005-01-26 : 00:42:53
|
| Hi,I need to limit the terminal that can connect to my DB. For instance, if the limit is 10 terminal then only 10 terminal that can connect to the DB server, the 11th terminal would be rejected. I cannot just hardcoded the terminal name. If 1 terminal create 2, 3 or even 10 connections to DB server, then it would still count as 1 terminal only.Is there any easy way to do this without using any code ?Regards,Mike |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-01-26 : 16:09:35
|
| No. You would need to code for this.Tara |
 |
|
|
Hyukevain
Yak Posting Veteran
66 Posts |
Posted - 2005-01-27 : 00:48:49
|
| I can create code by using sp_who then count how many terminal connected. Is there any other simpler way ? |
|
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2005-01-27 : 02:58:06
|
| How simple did you waqnt it to be?HTH=================================================================Our elections are free, it's in the results where eventually we pay. -Bill Stern, sports announcer (1907-1971) |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-01-27 : 04:39:54
|
| not sure but if you restrict the number of connections to the entire server, will that do?note: this is for entire server not just the database concerned--------------------keeping it simple... |
|
|
|
Hyukevain
Yak Posting Veteran
66 Posts |
Posted - 2005-01-28 : 00:31:05
|
| To Bustaz Kool : Maybe just like a schedule an store procedure that run every let say 1 minute to check how many terminal are connected then if the number is beyond the limit, kill the last connect terminal.To jen : Can I parameterize the setting, maybe by lookup from table ? |
|
|
|
|
|
|
Limiting User