Access active session data

If you want to check the properties of any active sessions on a database, you can with the following script.

SELECT
  TOP 100
  *
FROM
  sys.dm_exec_sessions

You need to run it while connected to the database you wish to query.

You can also easily filter the results using login_name to find your own sessions.

Subscribe

0 comments