All geek questions in one place

Can I get the client process identifier for an application running on an SQL server?

For my VFP application, I have a program to check currently who is accessing the server (using sp_who2), as well as another program to check who is currently blocking this table.

But I want to know what options are available to my users at the moment. I think if I can write SP to get the current process identifier for a specific client and paste it into a table (ActLog) in SQL with the program name skipped in this table when the user loads the program. And delete this particular entry when the user unloads the program.

Then from ActLog I can find out who is currently accessing which program. At the moment I want to know if I can get the client process ID?

Rgds / Andrea

+4
source share
1 answer

host_process_id in sys.dm_exec_sessions :

The identifier of the client program process that initiated the session

+4
source

Source: https://habr.com/ru/post/1311575/

More articles:


All Articles