Useful DMV Uses

Shows connections as well as the login name. A Where clause can of course be added to filter to a certain username or client (login_name or client_net_address) if required.

	,h.text last_query
from sys.dm_exec_connections c
join sys.dm_exec_sessions s
on c.session_id = s.session_id
cross apply sys.dm_exec_sql_text(c.most_recent_sql_handle) as h

Posted in Databases, Databases with : SQL Server