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.
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.
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?
rgds/Andrea
ClientProcessID. The ID assigned by the host computer to the process where the client application is running. This data column is populated if the client process ID is provided by the client.
Once we connect to a SQL Server instance, it assigns a unique identification number to each connection. It is the Server Process ID and commonly known as SPID. SPID 1 to 50 is reserved for SQL Server internal processes, and the user process starts from SPID 51.
@@SPID returns the session ID of the current user process of the SQL connection. We get smallint value as a session id from this function. SPID is a key value that administrators can use to track the activities of the users sessions in the server.
host_process_id
in sys.dm_exec_sessions
:
Process ID of the client program that initiated the session
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With