Home Forums SQL Server 2005 Administering Locks - Blocked Processes RE: Locks - Blocked Processes

  • August 17, 2009 at 12:53 pm

    #1040424

    The view, sys.sysprocesses will help you in all what you need.

    example: select * from sys.sysprocesses where blocked =1