Is it possible to get the text of the query that caused the trigger within a statement level trigger? It looks to me like all you can get is whether it is a an UPDATE, DELETE, or INSERT and not much in the way of details about the what caused the trigger. Thanks, Derry Bryson __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
