Linked Server中的存储过程问题
dwei 2005-03-16 03:05:26 单独运行Linked Server中存储过程,
exec [10.194.1.16].[SSS].[dbo].ufo_FQ_SPC_Defect
正常返回结果,
但是用如下语句却有错误,
insert into tbINT
exec [10.194.1.16].[SSS].[dbo].ufo_FQ_SPC_Defect
错误信息:
The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction.
[OLE/DB provider returned message: New transaction cannot enlist in the specified transaction coordinator. ]
OLE DB error trace [OLE/DB Provider 'SQLOLEDB' ITransactionJoin::JoinTransaction returned 0x8004d00a].
我在另外一台数据库服务器上运行,却都可以,
请高手解答,哪里有问题,
如何更改配置,使前一台服务器可以执行Insert语句。
谢谢!
^_^