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 Users
Guide for additional information on transaction isolation
levels.
