Applications must pay special attention to commands related to:
The XA Interface uses an ANSI default isolation level
of 3. To minimize read-only locking, programs can set the transaction
isolation level in the XA configuration file, or they can use select
xxx from table noholdlock in individual SQL operations.
See the Transact-SQL User’s Guide for
additional information on transaction isolation levels.