Friday, 28 September 2012

SQL Profiler who is using SPID

We have had multiple applications querying database and we needed to identify where they are comming from.

To identify pc where the call originated you can use sql command.

SELECT * FROM sysprocesses WHERE spid = 56

NOTE: You have to run in agains MASTER database

In response search for hostname.
The value could be somethind like: DESKTOP