SQL Server Delete Trigger is Firing When Transaction Rolled Back -


i have strange situation. in .net wrapping number of table inserts in transaction using transactionscope. have triggers each of insert, delete, update log history in table. expected, if exception occurs, transaction rolled , inserts removed. strange thing causing delete trigger run, , of delete log records in history table. should happening , there way avoid it?


Comments

Popular posts from this blog

Capture and play voice with Asterisk ARI -

java - Why database contraints in HSQLDB are only checked during a commit when using transactions in Hibernate? -

visual studio - Installing Packages through Nuget - "Central Directory corrupt" -