Home Forums SQL Server 2005 Administering Command to know no of users connected to particular database? RE: Command to know no of users connected to particular database?

  • Hmmm how about...

    select count(*) from sys.dm_exec_requests where db_name(database_id) = 'MyDatabaseName'