CODEWITHSUNDEEP
sql-serverloggingtriggersrdbmsldf
Cool Breeze
Cool Breeze

Reputation: 1369

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?

Upvotes: 1

Views: 438

Answers (1)

Cool Breeze
Cool Breeze

Reputation: 1369

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

Upvotes: 1

Related Questions