View Current Sessions

The sys.dm_exec_sessions dynamic management view provides information about the sessions that are established on the SQL Server instance.

SELECT * FROM sys.dm_exec_sessions;