Hi,

When i run a stored procedure i am getting the following
error in sql server 2000.

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

How can i solve it ?

Regards,
Anand

Is MSDTC started ?


--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Anand" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Hi,

Yes. MSDTC is also started up. Still it shows me the same
Error.

This SP, calls up remote servers(linked server) and it
internally calls up 20-30 procedures.

And it runs more than 2 hours.

And so i am not able find exactly where the error occurs ?

Can u help me in resolving it ?

With Regards,
Anand

Is SQL Server the ony guy involved ? Are there any other DB providers in
the mix

--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

<anonymous (AT) discussions (DOT) microsoft.com> wrote