Monday, 26 September 2016

Lock Request time out period exceeded.

If the table or Stored procedures has locked by Sql server means Use the below Commands to release.


TO check Due to which operation its got blocked:
DBCC opentran()

To see in detail.
sp_who2 70
sp_lock 70

Kill That transaction
KILL 70

No comments:

Post a Comment