Distributed transactions

Hi everyone!
My problem: I′m Apttempting to execute a Insert statement on a table in my
server with a SP from another. Like this:
INSERT INTO TABLE EXEC [TheOtherServer].[DataBase].dbo.stored_procedure
and I get this error message:
Server: Msg 7391, Level 16, State 1, Line 9
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].
My cuestion is: How can I configure the other server to allow distributed
transactions? and, Is this a solution or am I wrong?
Thanks a lotHi
You may wish to check that MS DTC is configured and working correctly.
http://support.microsoft.com/defaul...kb;en-us;329332
This may also help
http://support.microsoft.com/defaul...kb;en-us;306212
John
"Huacuz" wrote:

> Hi everyone!
> My problem: I′m Apttempting to execute a Insert statement on a table in m
y
> server with a SP from another. Like this:
> INSERT INTO TABLE EXEC [TheOtherServer].[DataBase].dbo.stored_procedure
> and I get this error message:
> Server: Msg 7391, Level 16, State 1, Line 9
> 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].
> My cuestion is: How can I configure the other server to allow distributed
> transactions? and, Is this a solution or am I wrong?
> Thanks a lot