Mapping spid to windows login to user query

• shoyt

  SSC Enthusiast

  Points: 176

  More actions

  May 7, 2003 at 4:01 am

  #64215

  Hello,

  Here is my scenario:

  Our clients access their database via IIS with their windows account. When their session is established, their login shows up as a SQL login we assigned to the database. The dillema I have is when I am trying to troubleshoot a runaway query. Since all the clients come into SQL with the SQL login instead of their Windows login, it is near impossible to narrow down whose query it is. My question is, is there a way to map a spid to the windows login and then to the actual T-SQL language. This would allow me to analyze the query and educate the user if it is inefficient. Feedback would be greatly appreciated.

• Allen Cui-55137

  SSC Guru

  Points: 51650

  More actions

  May 7, 2003 at 7:48 am

  #456393

  Try this.

  select spid, hostname, program_name, nt_domain, loginame from sysprocesses