General information
Forum:
Microsoft SQL Server
Title:
Trigger Invocation Cancel All Work
Hello,
I need some help about this:
I've a trigger in a table that writes some data in another table of another database, but the main problem it's when the local application send a group of updates to the triggered table all the process betewwen this instructions
set implicit transaction on
insert into table1 (...)
update table 2 (...) /* This it's the triggered table */
'IF @@TRANCOUNT > 0 COMMIT TRAN'
set implicit transaction off
simple disapear! It's like the transactions were not comitted...
Ideas?!
Thanks,
Manuel Almeida
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only