The first query succeeds because it executes under the context of a local
transaction on the remote server. The second query is failing as it needs a
distributed transaction as it involves operations in both local and remote
server and the remote transaction fails to join the local DTC transaction.
The following must be enabled for the distributed transaction to work
-XACT_ABORT should be on.
-REMOTE_PROC_TRANS must be set to 1
-MSDTC must be enable to allow dtc access. You may want to try the
1. start the MSDTC service
2. from "administrative tools" -> "component services" -> "computers" ->
"my computer" right click "properties"
goto MSDTC tab and select "security configuration", enable checkbox
for "network dtc access" and "allow outbound".
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
This posting is provided "AS IS" with no warranties, and confers no rights.