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?

  • April 13, 2009 at 4:22 am

    #976450

    Hi Koti,

    Can you try this

    select * from sys.sysprocesses where spid >50 and dbid= dbid