Does anybody has a script/stored-procedure to general a report/output about SQL 2000's Lock Owner Blocks in order to collect the real-time statics? It can be run by manually or certain interval (like every 5 mins). I know we can use sql-profiler or performance monitor to do this. But I need a script like this also. Thanks.