SP_WHO and SP_WHO2
These commands return information regarding the connections to the SQL Server.
SP_WHO2 returns more details such as date and time and CPU usage.
This can be useful when you are trying to determine if anyone is on. You will see the machine name and logged on user, as well as the database that is connected to the specified application.