Find who's locking your records

When developing in SQLServer, it is often you may find someone has your record(s) locked and you can't get to them.  By querying the system databases you can quickly find out who is blocking your progress using the following query to identify the process which you can then investigate on Task Manager on the server.



Hide comments


  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.