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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Determine how many users logged into SQL Server 2000 Database

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-10-18 : 09:33:27
Guy writes "How can i determine, at any given time, how many users are logged into a specific database in SQL Server 2000? Im using Windows Authentication but may be moving to mixed mode.

My scenario is that this needs to be checked when users log in so the number of licences they have is not exceeded. Its predominantly for an Access 2000 adp project with SQL server 2000 but will be moving over to vb pretty soon."
   

- Advertisement -