求解A、B两台服务器,windows2003 server操作系统,sql server2005,做链接服务器,没有事务时更新数据不报错,启用事务时更新数据出错,出错信息:
导入 Microsoft 分布式事务处理协调器(MS DTC)事务失败: 0x8004d01f(XACT_E_TIP_CONNECT_FAILED)报错语句:
begin tran
update LinkserverXX.Tesb_db.dbo.XXTable set fname = 'xxx' where fid = 1
commit transql2005 ;链接服务器
导入 Microsoft 分布式事务处理协调器(MS DTC)事务失败: 0x8004d01f(XACT_E_TIP_CONNECT_FAILED)报错语句:
begin tran
update LinkserverXX.Tesb_db.dbo.XXTable set fname = 'xxx' where fid = 1
commit transql2005 ;链接服务器
SQLServer事务的隔离级别有:
1. READ UNCOMMITTED 2. READ COMMITTED 3. SERIALIZABLE 更多参考:
http://www.cnblogs.com/qanholas/archive/2012/01/02/2310164.html