The SQL Server Blocked Process Monitor makes monitoring, tracking and troubleshooting SQL Server 2008 and 2005 blocked processes easy. You will no longer have to manually enable and run a trace to capture the blocked process report. In addition, the application will parse the Report XML and use the sqlhandle information contained in the report to capture the actual sqltext from the sys.dmexecsql_text DMV as the blocking occurs. There are 2 versions of the application, one targeted at SQL Server 2008, and one at SQL Server 2005. You can download from CodePlex here.