var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: doing transactions with linked server(ole db provider)
When i begin a distributed transaction..., do i need to always
set xact_abort on?
But when i tried to put custom error handling to roll back a transaction with a linked server , it seems its impossible (as set xact_abort on, already automatically rolls back the transaction)
Does anyone have any ideas on this?
Thanks in advance
set xact_abort on is not required for distributed transactions.
But i get an error when i dont set that.
Do you know what has to be done instead?
Thanks for your feedback