Can trigger firing/execution be viewed in Profiler?

If so, how? I've looked through all the event classes and don't see
anything about triggers.
Also, I added the DatabaseName column to my trace but all the entries
have this column set to NULL. Is there something I need to do to get
this column populated correctly?
Thanks!If you add SP:StmtStarting or SP:StmtCompleted events, you will see trigger
execution.
See if you can get Database ID column populated. This way you can resolve
the name using DB_NAME() function.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
What hardware is your SQL Server running on?
http://vyaskn.tripod.com/poll.htm
"Franklin Bowen" <FranklinBowen@.hotmail.com> wrote in message
news:9142752b.0309100902.6e873a1a@.posting.google.com...
If so, how? I've looked through all the event classes and don't see
anything about triggers.
Also, I added the DatabaseName column to my trace but all the entries
have this column set to NULL. Is there something I need to do to get
this column populated correctly?
Thanks!