SQL Server System SP to detech who's Login to what database?

Hi guys,

I double check one time the Database Server SQL Server (its a test Server) and i saw in the Event Viewer that one programmer is Logging In (Security - Success Audit)

I am no DBA but i would like to know what SP to run to check on who's login in the SQL Server Database and to what database? Provided that those user logging in uses the SA or Admin Users.

Thanks a lot!
- Vincent

sp_Who

returns a list of everybody connected to the server and what database... even shows the current commend executing, and other neat items.

-tg

There is also another flavor - EXEC SP_WHO2 - with some different columns of info.

Is there a LOG file to view where a certain user connects to what Database Object at a specific date & time?

sp_who only shows the active users connected...

Thanks again!