Not a trigger but you can write an sp and schedule it to run frequently. You probably wouldn't want to kill this sort of process immediately anyway.
Another option would be to use the profiler to log the events to a table and put trigger on the table.
========================================== Cursors are useful if you don't know sql. DTS can be used in a similar way. Beer is not cold and it isn't fizzy.
If you're getting to the point where locks are this bad, you should probably look at using WITH(NOLOCK) strategically and a possible redesign on your tables. Have you thought about that? You can find the contention areas by using Profiler like Nigel suggested.
Trigger for lock event.
Posted - 04/17/2004 : 03:57:32
