Determining users logged on in a database.

[McCabeTC]

Hi,

I know this forum is mostly for SQL programming issues, but I was wondering if anybody knows of a tool (as part of SQL Server or not), that would allow me to see all the users logged on/using a particular database at a certain time (maybe something similar to LDB Viewer for Access?). I do not know much about SQL administration; therefore, I would appreciate any help you can give me on that.

Thank you,

TM

 

[gmmastros]

You can use the system stored procedure "sp_who" to see who is logged in to the server. The database that they are logged in to will also display.



-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[McCabeTC]

George,

Thank you very much for your help.

TM

 

[gmmastros]

You're welcome.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom