两台电脑,局域网的,同装了SQL 2005 EXPRESS,写了两个存储过程,客户机可以以事务处理从服务器下载数据,可是却不能以事务处理向服务器写数据,提示:导入 Microsoft 分布式事务处理协调器(MS DTC)事务失败: 0x8004d01f(XACT_E_TIP_CONNECT_FAILED)有人知道是怎么回事吗?下载的存储过程这样写的:(这个可以执行)
USE [wqjxc_sale]
GO
/****** 对象: StoredProcedure [dbo].[update_spzl] 脚本日期: 03/26/2011 13:52:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GOCREATE PROC [dbo].[update_spzl]
AS
BEGIN
set xact_abort ON
BEGIN TRANSACTIONif exists (select * from sysobjects where name = 'spzl') drop table spzl
if exists (select * from sysobjects where name = 'usertable') drop table usertable
if exists (select * from sysobjects where name = 'syspara') drop table syspara
if exists (select * from sysobjects where name = 'stock') drop table stock
if exists (select * from sysobjects where name = 'report') drop table report
if exists (select * from sysobjects where name = 'ckzl') drop table ckzl
if exists (select * from sysobjects where name = 'DaBaoDetail') drop table DaBaoDetail SELECT * INTO stock FROM x60t.WQJXC.dbo.stock
SELECT * INTO spzl FROM x60t.WQJXC.dbo.SPZL
SELECT * INTO UserTable FROM x60t.WQJXC.dbo.UserTable
SELECT * INTO syspara FROM x60t.WQJXC.dbo.syspara
SELECT * INTO report FROM x60t.WQJXC.dbo.report
SELECT * INTO ckzl FROM x60t.WQJXC.dbo.ckzl
SELECT * INTO DaBaoDetail FROM x60t.WQJXC.dbo.DaBaoDetail UPDATE LUT SET LastUpdateTime = (GETDATE()) COMMIT TRANSACTION
--END TRY
--ROLLBACK TRANSACTION
END
上传的存储过程是这样写的:(不可以执行)
USE [wqjxc_sale]
GO
/****** 对象: StoredProcedure [dbo].[upload] 脚本日期: 03/26/2011 13:53:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GOCREATE PROC [dbo].[upload]
AS
BEGIN
set XACT_ABORT on
BEGIN TRANSACTION
INSERT INTO x60t.wqjxc.dbo.SaleMaster_Temp (dh,xstime,xsdate,syyid,yyyid,shoukuan,zhaohui,shuaka,yingshou,shishou,youhui,ckid,vipid,js)
SELECT dh,xstime,xsdate,syyid,yyyid,shoukuan,zhaohui,shuaka,yingshou,shishou,youhui,ckid,vipid,js
FROM SaleMaster_Temp
WHERE upload = 0 UPDATE SaleMaster_Temp SET upload = 1 WHERE upload = 0 INSERT INTO x60t.wqjxc.dbo.SaleDetail_Temp (dh,bm,sl,jj,spsj,sjsj,ysxj,sjxj,zkl,yyyid)
SELECT dh,bm,sl,jj,spsj,sjsj,ysxj,sjxj,zkl,yyyid
FROM SaleDetail_Temp
WHERE upload = 0
UPDATE SaleDetail_Temp SET upload = 1 WHERE upload = 0COMMIT TRANSACTION
END
USE [wqjxc_sale]
GO
/****** 对象: StoredProcedure [dbo].[update_spzl] 脚本日期: 03/26/2011 13:52:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GOCREATE PROC [dbo].[update_spzl]
AS
BEGIN
set xact_abort ON
BEGIN TRANSACTIONif exists (select * from sysobjects where name = 'spzl') drop table spzl
if exists (select * from sysobjects where name = 'usertable') drop table usertable
if exists (select * from sysobjects where name = 'syspara') drop table syspara
if exists (select * from sysobjects where name = 'stock') drop table stock
if exists (select * from sysobjects where name = 'report') drop table report
if exists (select * from sysobjects where name = 'ckzl') drop table ckzl
if exists (select * from sysobjects where name = 'DaBaoDetail') drop table DaBaoDetail SELECT * INTO stock FROM x60t.WQJXC.dbo.stock
SELECT * INTO spzl FROM x60t.WQJXC.dbo.SPZL
SELECT * INTO UserTable FROM x60t.WQJXC.dbo.UserTable
SELECT * INTO syspara FROM x60t.WQJXC.dbo.syspara
SELECT * INTO report FROM x60t.WQJXC.dbo.report
SELECT * INTO ckzl FROM x60t.WQJXC.dbo.ckzl
SELECT * INTO DaBaoDetail FROM x60t.WQJXC.dbo.DaBaoDetail UPDATE LUT SET LastUpdateTime = (GETDATE()) COMMIT TRANSACTION
--END TRY
--ROLLBACK TRANSACTION
END
上传的存储过程是这样写的:(不可以执行)
USE [wqjxc_sale]
GO
/****** 对象: StoredProcedure [dbo].[upload] 脚本日期: 03/26/2011 13:53:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GOCREATE PROC [dbo].[upload]
AS
BEGIN
set XACT_ABORT on
BEGIN TRANSACTION
INSERT INTO x60t.wqjxc.dbo.SaleMaster_Temp (dh,xstime,xsdate,syyid,yyyid,shoukuan,zhaohui,shuaka,yingshou,shishou,youhui,ckid,vipid,js)
SELECT dh,xstime,xsdate,syyid,yyyid,shoukuan,zhaohui,shuaka,yingshou,shishou,youhui,ckid,vipid,js
FROM SaleMaster_Temp
WHERE upload = 0 UPDATE SaleMaster_Temp SET upload = 1 WHERE upload = 0 INSERT INTO x60t.wqjxc.dbo.SaleDetail_Temp (dh,bm,sl,jj,spsj,sjsj,ysxj,sjxj,zkl,yyyid)
SELECT dh,bm,sl,jj,spsj,sjsj,ysxj,sjxj,zkl,yyyid
FROM SaleDetail_Temp
WHERE upload = 0
UPDATE SaleDetail_Temp SET upload = 1 WHERE upload = 0COMMIT TRANSACTION
END
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货