View Users

[Saadiq]

Hi

What is the sql commnad to view active user on sql sever databases

Thanks

[Simon Hayes]

"Saadiq" <sa*********@yahoo.com> wrote in message
news:2d**************************@posting.google.c om...

Hi

What is the sql commnad to view active user on sql sever databases

Thanks

sp_who2 to see current current active connections, or sp_helpuser to see all
users and roles defined in the current database.

Simon