i am trying to execute a stored proc into a tempory table using a linked server.
create table #tmp_nowOrders( origText varchar(100), total int, paid int, canceled int, completed int, creditCard int, eCheck int, wu int, mg int,
lockbox int, agentStoreFront int, ace int, prePaidCard int, account int )
insert into #tmp_nowOrders( origText, total, paid, canceled, completed, creditCard, eCheck, wu, mg, lockbox, agentStoreFront, ace, prePaidCard, account )
EXEC ls_oms.orderManagement.dbo.report_InsideSalesPrepaidOrders '11/22/2004', '11/22/2004', 1
select * from #tmp_nowOrders
drop table #tmp_nowOrders
i keep getting this error:
Server: Msg 7391, Level 16, State 1, Line 7
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].
however, when i execute the contents of the stored proc, it works fine.
i have been poking around and found many references to sql2000 on win2k3 but that is not relivant.
both servers are running sql2000 the host is win2k adv serv the ls is win2k server. msdtc is running on both, and neither has enforce dtc checked.