SpoonHP:Is there a tool or procedure to be able to debug trigger? Per line exec or something similar? Checking the special trigger tables?
try this... http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=11600