Reserving Concurrent Users in MSSQL 2000

[sscoffey]

Does anyone know how to reserve a number of concurrent user licenses /per server logins in MSSQL 2000? I have a situation where I have more users than I have licenses for an enterprise SQL application and would like to make sure that a certain group of users always has access to the system. Individuals who only need inquiry access should only be allowed to login if there are licences available beyond the core group of users. Any Ideas? Thanks.

[rmiao]

No, can't do that in sql by default.

[MAK]

there is a round about way to do it.

you can run a procedure every min that checks the sysprocesses table. when the total number of connection exeeds you can kill the users who are not in the preferred login list.

whenever preferred login users logon you can kick some of the users who are not active and who are not important.