none
Host Process ID of all of the users RRS feed

  • Question

  • Hi,

     

    How to find the host process ID of all the users. I know to find for one user.But i need to find the Host process Id of all of the users.

     

    I need to know the login names and host process ids of all the Login names on a server using Tsql.

     

    Please let me know.

     

    Thank You very much,

    Tuesday, August 23, 2011 9:53 PM

Answers

  • Does sys.dm_exec_sessions DMV not give you what you are looking for, namely HOST_PROCESS_ID column?

     


    Mohit K. Gupta --- MCTS, MCITP, MCC2011 http://sqllearnings.blogspot.com/
    • Marked as answer by sqlenth Wednesday, August 24, 2011 1:28 AM
    Tuesday, August 23, 2011 10:41 PM

All replies

  • Does sys.dm_exec_sessions DMV not give you what you are looking for, namely HOST_PROCESS_ID column?

     


    Mohit K. Gupta --- MCTS, MCITP, MCC2011 http://sqllearnings.blogspot.com/
    • Marked as answer by sqlenth Wednesday, August 24, 2011 1:28 AM
    Tuesday, August 23, 2011 10:41 PM
  • Mohit,

     

    I was able to find out the required information from the dmv sys.dm_exec_sessions.

     

    Thank You very much for your help.

    Wednesday, August 24, 2011 1:28 AM