Search code examples
sql-serverloggingtriggersrdbmsldf

Does SQL Server create a log entry when an exception occurs in a Trigger?

My understanding is that when a Trigger fails then the entire transaction rolls back. Assuming this is correct does SQL server log these failures anywhere?

Would they be logged in the .ldf file? or are only successful transactions logged there?

Solution

  • In my development environment I was able to retrieve the aborted transactions using the ApexSQL transaction log reader.