>Is there a way to limit the number of users than can access a database in SQL Server? We license our software based on the number of concurrent users, and we want to enforce that limit. Basically, I need to know how many users are logged in to a database.
>
>Thanks.
Joel,
You'll get error number 18458 (All licensed connections are in use) from SQL Server, whenever someone tries to connect when the number of licenses are maxed out. I know that this doesn't specifically answer your question, but when you periodically get this message it basically means that you need to purchase new CAL licenses.
George
Ubi caritas et amor, deus ibi est