SQL: How to determine who is connected to your server

Here's how to determine who is connected to your SQL.

This is very helpful if you are moving your SharePoint from one SQL Instance to another

Steps:

1. Open up SQL Server Management Studio.
2. Execute a new query, type SP_Who and then run or execute the query.