How to find the association between SQL server SPID and domain/mdw logon? - TechRepublic
Question
June 5, 2007 at 09:00 PM
derek369

How to find the association between SQL server SPID and domain/mdw logon?

by derek369 . Updated 17 years, 5 months ago

We use ODBC connecting MS Access application (frontend) to MS SQL server 2000 database. Users log on Citrix server to run frontend application. The application share the same ODBC Data Source serverwide. Users logon Citrix server using domain logon and log in Access applcation using login contained in .mdw (workgroup).

MS SQL Enterprise Manager shows which SPID is blocking and which SPID is blocked. What I want to find out which domain user is blocking? In other words, Is there any way to find out which SPID is associated with which domain user or Access login contained in mdw file(not database login)?

Thanks in advance!
Derek

This discussion is locked

All Comments