• The easiest way to see that is through the dynamic management views. CLIENT_INTERFACE_NAME in SYS.DM_EXEC_SESSIONS

    SELECT s.session_id, s.host_name, s.program_name, s.client_interface_name, s.login_name, s.status AS session_status,

    db_name(er.database_id) AS database_name,

    er.status AS request_status, er.command, er.percent_complete,

    er.blocking_session_id,

    er.wait_type, er.wait_time / 1000.0 AS wait_sec, er.last_wait_type, er.wait_resource,

    er.transaction_id, er.open_transaction_count,

    er.cpu_time / 1000.0 AS cpu_sec, er.total_elapsed_time / 1000.0 AS total_elapsed_sec, er.start_time, er.reads, er.writes, er.logical_reads,

    er.sql_handle, er.plan_handle

    FROM sys.dm_exec_requests er

    INNER JOIN sys.dm_exec_sessions s ON er.session_id = s.session_id

    WHERE s.is_user_process = 1

    AND s.session_id <> @@SPID