> I want to get the code of the sql statement that fires trigger ...
> if i have after insert trigger when an insert statements is executed i want to get the sql code of that insert into the trigger ...

I think, the insert statement isn't directly linked to the trigger
firing on that in the trace, except for the trigger, also the table name
is part of the trace output and an identical transaction id might also
be somekind of key that they are linked "together".


--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com
My blog:
http://blog.upscene.com/thomas/