Home Forums SQL Server 2008 SQL Server 2008 Administration Need a blocking script with specific details RE: Need a blocking script with specific details

  • July 23, 2013 at 10:37 am

    #1635068

    you can check where blocked != 0 from master..sysprocesses table.

    you can also use profiler now to trap information on blocks.

    ---------------------------------------------------------------------