SP Not calling across servers!!!

[robwheels]

Our office is having issues with server performance when sp's. We are not sure why.
I do not know all the specifics on the server(s), except they are running win2k with SQL2k with sp3.

Bottom line:

We are running stored procedures on box A which call data(select statement) from box B. This works fine, but very slow!

We have tried creating a sp on box B, then run an insert into statement calling a sp:

NSERT INTO #ARReceivableByDays_server A_DATA
EXEC ServerA.xxx.dbo.SpRpt_GetAgedAR --'1/1/06','1/25/06','080','ALL','ALL','ALL'
@ld_minDt

The exe fails every time on the insert statement, it returns msg:

Server: Msg 7391, Level 16, State 1, Procedure SuspendTest, Line 73
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].

This only happens when stored procs are called. Selects work fine across servers. As far as I know all DTC services are running. Any help would be appreciated.

 

[SQLSister]

look at this Microsoft knowledgebase article:

http://support.microsoft.com/kb/329332/en-us

It helped us when we had that problem.

Questions about posting. See faq183-874
Click here to help with Hurricane Relief

 

[robwheels]

We did, but the infastructure group claimed this only applied to Server 2003. I'll bring it up again. Thanks.