出现这个错误信息是怎么回事，如何解决呢？

l_agang 2002-11-27 02:49:50

1、我自己编写了一个存储过程大致如下：
CREATE PROCEDURE USP_YX_TransmitData
@DesServer varchar(50),
@DesDataBase varchar(50)
as
begin tran
declare @ServerConnection varchar(100)
declare @Sql varchar(2000)
declare @TableName varchar(50)
declare @ServerRecID Varchar(50)
declare @OperateType int
set @ServerConnection=@DesServer+'.'+@DesDataBase+'.dbo.'

declare ChangeLogCur cursor for select * from TB_YX_ChangeLog order by FD_TableName,FD_ServerRecID,FD_OperateType
open ChangeLogCur
FETCH NEXT FROM ChangeLogCur INTO @TableName,@ServerRecID,@OperateType
WHILE (@@FETCH_STATUS <> -1)
begin
if @TableName='TB_YX_BroilingTicket'
begin
if @OperateType=1
begin
set @Sql='insert into '+@ServerConnection+@TableName+
' (FD_TicketCode,FD_Station,FD_StationID,FD_Dept,FD_Principal,FD_Group,FD_Member,FD_Amount,FD_TaskContent,FD_ForeStartTime,FD_ForeEndTime,FD_NeedMeasure,FD_SignMan_Out,FD_SignDate,FD_AddMeasure,FD_StartTime,FD_PermissionMan_Start,FD_Principal_Start,FD_FinishTime,FD_Principal_Finish,FD_State,FD_BackUpDate) '+
'select FD_TicketCode,FD_Station,FD_StationID,FD_Dept,FD_Principal,FD_Group,FD_Member,FD_Amount,FD_TaskContent,FD_ForeStartTime,FD_ForeEndTime,FD_NeedMeasure,FD_SignMan_Out,FD_SignDate,FD_AddMeasure,FD_StartTime,FD_PermissionMan_Start,FD_Principal_Start,FD_FinishTime,FD_Principal_Finish,FD_State,FD_BackUpDate from '+@TableName+' where FD_ServerRecID is NUll'
exec(@Sql)
end
end
FETCH NEXT FROM ChangeLogCur INTO @TableName,@ServerRecID,@OperateType
end
CLOSE ChangeLogCur
DEALLOCATE ChangeLogCur
commit tran

2、用以下语法调用该存储过程：
USP_YX_TransmitData 'Server','DBTransStation'

3、提示以下错误信息
Could not start a transaction for OLE DB provider 'SQLOLEDB'.
[OLE/DB provider returned message: Cannot start more transactions on this session.]

4、出现这个错误信息是怎么回事，如何解决呢？

...全文