Re: How can I know?

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 02/24/05 

Date: Thu, 24 Feb 2005 09:01:51 -0500

You can run sp_who2 and count the ones in the specific db. Or you can run a
select against master..sysprocesses and filter on the correct DBID. 

-- 
Andrew J. Kelly  SQL MVP
"hui" <jxmu_lhf71@163.com> wrote in message 
news:ODVQAhnGFHA.2280@TK2MSFTNGP15.phx.gbl...
>I wanna know how I could know how many users or who are logging into some
> database.
>
> thanks in advance
>
>

Relevant Pages

  • Re: OO vs. RDB challenge
    ... > Layer 1. ... If you filter your data after you retrieve it, ... possible to redesign the database schema to enable SQL to do its job. ... A good RDBMS could integrate an external authentication server. ...
    (comp.object)
  • Re: Access module does not continue past the Filter Method
    ... If you get this problem in any database at all, ... the subroutine went back to not working again. ... Public Sub Apply_Tech_Filter ... Debug.Print "Past the Filter" ...
    (microsoft.public.access.modulesdaovba)
  • Re: Lots of Bits
    ... and performance is perhaps increased for the database. ... purist might frown upon it for more theoretical purposes as well as the many ... > match customer filter values with campaign filter values. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Access module does not continue past the Filter Method
    ... I have only seen the problem of "no runtime error messages" in this database. ... Public Sub Apply_Tech_Filter ... Debug.Print "Past the Filter" ...
    (microsoft.public.access.modulesdaovba)
  • RE: [fw-wiz] (no subject)
    ... You can filter in the PIX dropping logging of mundane things like ... > i have cisco pix firewall that is sending it log data to a cisco syslog ...
    (Firewall-Wizards)