How to Find Who Is Using SQL Server

Why How to Find Who Is Using SQL Server is important

-- Which users are currently creating new Orders?
SELECT
    s.login_name,
    r.command,
    r.start_time,
    QUOTENAME(c.database_id) AS db_id,
    SUBSTRING(st.text, r.statement_start_offset/2, 
                      (CASE WHEN r.statement_end_offset = -1 
                            THEN LEN(CONVERT(NVARCHAR(MAX), st.text))*2 
                            ELSE r.statement_end_offset END - r.statement_start_offset)/2) AS sql_text
FROM sys.dm_exec_sessions            AS s
JOIN sys.dm_exec_connections         AS c ON s.session_id = c.session_id
JOIN sys.dm_exec_requests            AS r ON s.session_id = r.session_id
CROSS APPLY sys.dm_exec_sql_text(r.sql_handle) AS st
WHERE DB_NAME(c.database_id) = 'Orders'
  AND r.command LIKE '%INSERT%';

-- Quick check with built-in proc
EXEC sp_who2;

-- Detailed DMV pattern
SELECT
    s.session_id           AS spid,
    s.login_name           AS login,
    s.host_name            AS workstation,
    c.client_net_address   AS ip,
    DB_NAME(c.database_id) AS database_name,
    r.status,
    r.command,
    r.cpu_time,
    r.blocking_session_id  AS blocker
FROM sys.dm_exec_sessions    AS s
JOIN sys.dm_exec_connections AS c ON s.session_id = c.session_id
LEFT JOIN sys.dm_exec_requests   AS r ON s.session_id = r.session_id
WHERE s.session_id  > 50 -- skip system processes
  AND DB_NAME(c.database_id) = 'Orders';