Monday, July 29, 2013

how to see log how many times trigger on my table executed

The LOG file is not intended to be read by humans. There are some third party log reader products, but I have no idea how dependable they are, since the format of the LOG file is not documented.



If you want to keep track of how often triggers execute, just add a table with a counter and increase that counter from within the trigger.


-- Hugo Kornelis, SQL Server MVP

No comments:

Post a Comment