Hi,

We are facing some blocking problems on the server (SQLServer 6.0).
I need to trace the locks held by various sql statements. Basically
I want to findout the duration for which `Update Page Locks` are
held.

Any idea how can cause a trigger to work on system tables ?
I tried writing a trigger on syslocks table, but that never
gets fired.

Also I have seen a trace flag that will return the process id
requesting a lock and the time it requested or released the
lock. I can`t seem to find the trace flag number. Can anyone help me with
this ?

Thanks a million,
Balaji.