While I was at the SQL Server User Group last night, I brought up the recent problem my company has been having with deadlocks - where we needed to find who was ACTUALLY causing the locks (not the parent SPID, but the low level trigger or nested SQL SPROC). I was told to periodically check the sysprocesses...