Guest User

Untitled

a guest
Feb 18th, 2019
95
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.79 KB | None | 0 0
  1. select login_name, session_id, host_name, host_process_id
  2. from sys.dm_exec_sessions where host_process_id = XXXX AND session_id = YY
  3.  
  4. EXEC xp_readerrorlog 0, 1, N'kill', NULL, NULL, NULL, N'DESC'
  5.  
  6. LogDate ProcessInfo Text
  7. ----------------------- ------------ ----------------------------------------------------------------------
  8. 2017-06-20 07:17:32.210 spid64 Process ID 62 was killed by hostname JOHNLAPPY, host process ID 7968.
  9.  
  10. (1 row(s) affected)
  11.  
  12.  
  13.  
  14. select login_name, session_id, host_name, host_process_id from sys.dm_exec_sessions where host_process_id = 7968 AND session_id = 62
  15.  
  16. login_name session_id host_name host_process_id
  17. ----------------------- ---------- ---------- ---------------
  18. CONTOSOjohn.eisbrener 62 JOHNLAPPY 7968
  19.  
  20. (1 row(s) affected)
Add Comment
Please, Sign In to add comment