Unanswered: Insert/Update/Delete Problem in Distributed Transactions
I have 2 MS SQL SERVER 2000 instances named a and b.
I have a linked server from a to b named ab.
Now, when i try to update a table from a to b using linked server "ab",
it showed error like cannot perform netsted transactions using sqloledb. The solution given was to use SET XACT_ABORT ON and use
This is working fine when i do the same from SQL Query Analyser.
But, my problem is i am doing the update from lot of java programs.
So, Can Anyone Help me to find out how to do
SET XACT_ABORT ON Property in SQL Server Globlally, so that whenever i open an session, it is by default ON.
Note : Now Currently SET XACT_ABORT Property is OFF.