Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- KILL 1132
- GO
- SELECT
- p.spid, p.STATUS, p.hostname, p.loginame, p.cpu, r.start_time, t.text
- FROM
- sys.dm_exec_requests AS r,
- master.dbo.sysprocesses AS p
- CROSS APPLY sys.dm_exec_sql_text(p.sql_handle) t
- WHERE
- p.STATUS NOT IN ('background')
- AND r.session_id = p.spid
- ORDER BY r.start_time
Advertisement
Add Comment
Please, Sign In to add comment