Home Forums Article Discussions Article Discussions by Author Discuss content posted by Jonathan Kehayias Using the Blocked Process Report in SQL Server 2005/2008 RE: Using the Blocked Process Report in SQL Server 2005/2008

  • January 5, 2012 at 12:32 am

    #1428807

    Jonathan Kehayias (1/4/2012)

    Yes, the root of the blocking could be from a previous statement in a transaction.

    Thanks. I again lost hope to capture the query that caused blocking in SQL Server. However, with the Blocked Process Report, I can at least identify the transaction responsible.