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 |
|
dowens
Yak Posting Veteran
82 Posts |
 Posted - 2005-11-03 : 14:54:34
|
| SQL2000Is there a way to limit the number of logons by user?If so how? |
|
|
SQLServerDBA_Dan
Aged Yak Warrior
752 Posts |
Posted - 2005-11-03 : 15:37:49
|
Get a ruler and smack the users in the hand when they exceed your specified limits. They'll learn not to have too many connections open.  I don't know of a way by user. You can limit it to a # of connections but one user could use all of those connections. |
 |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-11-03 : 21:54:22
|
| Control through an application. You can track computer addresses and figure it out if you are really that interested in it. Do you mean logins or connections?MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
How do I limit the number of logons