Relation between SQL Server login and session

• arthurpogh

  Grasshopper

  Points: 15

  More actions

  October 19, 2015 at 12:55 am

  #304366

  Hi people

  I have question, how can I determine the relation between MS SQL Server user (SQL login ) and his session , when it connect to SQL Server

  Thank in advance

• SpeedySQL

  Ten Centuries

  Points: 1019

  More actions

  October 23, 2015 at 6:07 am

  #1835134

  What do you mean by relation? You can get the session ID using the following DMV:

  SELECT

  session_id

  ,login_name

  FROM sys.dm_exec_sessions;

  SpeedySQL