How can I know?

I wanna know how I could know how many users or who are logging into some
database.
thanks in advanceYou 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
>