title: Is it possible to get the client process ID of an application that runs on SQL server?
body: <p>For my VFP application, i have a program to check currently who is accessing the server (by using sp_who2), also another progam to check who is currently locking which table. </p>
  
  <p>But i wish to know which options my users is accessing at the moment. Am thinking if i can write a SP to get the current connected process ID for a specific client, and insert to a table(ActLog) in SQL with the program name pass into this table during users load the program. And delete that particular record when user unload the program. </p>
  
  <p>Then from the ActLog, i can know who is currently accessing to which program. 
  At the moment, i wish to know if i able to get the client process ID?</p>
  
  <p>rgds/Andrea</p>