<anonymous@discussions.microsoft.com> wrote in message
news:049401c3c2f6$2a074a10$a401280a@phx.gbl...
> 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
>
>
> >-----Original Message-----
> >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@discussions.microsoft.com> wrote in
> message
> >news:033301c3c0b1$3eab3d60$a001280a@phx.gbl...
> >> 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
> >
> >
> >.
> >