解決不了了﹐快點來救命呀
我有一個存儲過程en_knit_qty_by_lot_up﹐存儲過程里面有用到許多其它服務器上的數據﹐
現在我想將這個過程的最終結果集insert到另外一個臨時表中去﹐我的做法是
create table #test(combo_seq smallint, color_code char(15), color_desc char(30), lot char(15), net_qty numeric(9, 2), size_id char(10), qty int, size_seq int)
insert into #test(combo_seq, color_code, color_desc, lot, net_qty, size_id, qty, size_seq)
exec en_knit_qty_by_lot_up @lot_no
但是出現錯誤﹕
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到另一表中的問題﹐還有其它的做法嗎﹖