Find out who is currently connected with SQL Server and is Active.
sp_who2 active
To get the detail of one particular process ID
sp_who2 96
Get the detail of query running by any process ID found by above query:
dbcc inputbuffer(96)
To Kill session use:
Kill 96
sp_who2 active
To get the detail of one particular process ID
sp_who2 96
Get the detail of query running by any process ID found by above query:
dbcc inputbuffer(96)
To Kill session use:
Kill 96
No comments:
Post a Comment