Saturday, 20 May 2017

Unlock a table using sql server

// Sql Query

select * from  sys.dm_exec_requests

// Result





where status got suspended, get the session_id  of that and execute the query
Query-

kill 57

Related session_id rows status has been changed.

No comments:

Post a Comment

How to highlight selected text in notepad++

  –> To highlight a block of code in Notepad++, please do the following steps step-1  :- Select the required text. step-2  :- Right click...