Is it possible to get the client process ID of an application that runs on SQL server?

Posted by Andrea.Ko on Stack Overflow See other posts from Stack Overflow or by Andrea.Ko
Published on 2010-06-02T01:33:38Z Indexed on 2010/06/02 1:43 UTC
Read the original article Hit count: 603

Filed under:

sql-server

|

vfp

Hi all,

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

© Stack Overflow or respective owner

Related posts about sql-server

SQL SERVER – Beginning SQL Server: One Step at a Time – SQL Server Magazine

as seen on SQL Authority - Search for 'SQL Authority'
I am glad to announce that along with SQLAuthority.com, I will be blogging on the prominent site of SQL Server Magazine. My very first blog post there is already live; read here: Beginning SQL Server: One Step at a Time. My association with SQL Server Magazine has been quite long, I have written nearly… >>> More
How to install SQL Server 2005 Configuration Manager without installing SQL Server Management Studio

as seen on Server Fault - Search for 'Server Fault'
Hi, I need to configure SQL Server aliases on a public-facing production server. To do that, I need to install SQL Server Configuration Manager. I was not able to find a standalone installer for that, so I am having to install SQL Server 2005 Client Components. This approach is not ideal as we don't… >>> More
[MAJ] SQL Server 2005 Express Edition - La version gratuite de SQL Server 2005

as seen on ASP-PHP.net - Search for 'ASP-PHP.net'
Modification technique pour le site de l'article. >>> More
How to create SQL Server Express DB from SQL Server DB

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a SQL Server 2008 DB. I want to extract SOME tables (and associated schema, constraints, indexes, etc) and create a SQL Server Express DB. It isn't a sync of the target, we stomp on it. We ONLY need to do this in the file system (not across the wire). We are not fond of the synchronization… >>> More
sql server 2000 error, error trying to connect to sql server 2005

as seen on Stack Overflow - Search for 'Stack Overflow'
i am connecting to sql server 2000 on a remote computer with a dotnet application, but when i try to open the connection it gives the following error: When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections What… >>> More

Related posts about vfp

Error installing scipy on Mountain Lion with Xcode 4.5.1

as seen on Super User - Search for 'Super User'
Environment: Mountain Lion 10.8.2, Xcode 4.5.1 command line tools, Python 2.7.3, virtualenv 1.8.2 and numpy 1.6.2 When installing scipy with pip install -e "git+https://github.com/scipy/scipy#egg=scipy-dev" on a fresh virtualenv. llvm-gcc: scipy/sparse/linalg/eigen/arpack/ARPACK/FWRAPPERS/veclib_cabi_c… >>> More
COPY TO xxxx.xls TYPE XLS (VFP 8.0 SP1)

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi All, I downloading table from SQL 2008 using VFP 8.0 (SP1) using command: COPY TO xxx TYPE XLS Some of the data in the excel is disappearing. Example, Table in SQL: Cus(ID int(4), CusNam VARCHAR(35)) When i issue the following command at VFP Forms: (a) COPY TO xxx TYPE FOX2x [Data display… >>> More
VFP Unit Matrix Multiply problem on the iPhone

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi. I'm trying to write a Matrix3x3 multiply using the Vector Floating Point on the iPhone, however i'm encountering some problems. This is my first attempt at writing any ARM assembly, so it could be a faily simple solution that i'm not seeing. I've currently got a small application running using… >>> More
Total pages in report of VFP 8.0 can be reset by data grouping?

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a report (using VFP 8.0) with a data grouping by Invoice Number, i need to reset the total of pages by changing of invoice number. I failed to do so, as the _pagetotal will always return total pages of all selected invoice. Please advice. >>> More
Adding new record to a VFP data table in VB.NET with ADO recordsets

as seen on Stack Overflow - Search for 'Stack Overflow'
I am trying to add a new record to a Visual FoxPro data table using an ADO dataset with no luck. The code runs fine with no exceptions but when I check the dbf after the fact there is no new record. The mDataPath variable shown in the code snippet is the path to the .dbc file for the entire database… >>> More