Hi Guys,
I got an error about trace flag 8588, Error 8526 Level 16: Cannot go remote
while the session is enlisted in a distributed transaction that has an activ
e
savepoint. I setup two sql server 2000 in two windows 2003 server, both
install sql server sp1. I created linked server and setup MCDTC on both
server. When I run application that include distributed transaction, I got
error above. I re-check MCDTC, permission and so on, but I still got that
issue. Could some one help me to fix it? Thanks in advance.For more information about using trace flags and startup parameters, see the
"DBCC TRACEON" and "Using Startup Options" topics in SQL Server 2000 Books
Online.
To use trace flag 8599, obtain the latest service pack for SQL Server 2000:
Q290211 INF: How to Obtain the Latest SQL Server 2000 Service Pack
Once you update the service pack your problem will get fixed. Please update
the same and lemme know if it works...
Thanks,
Sree
[Please specify the version of Sql Server as we can save one thread and
time
asking back if its 2000 or 2005]
"Iter" wrote:
> Hi Guys,
> I got an error about trace flag 8588, Error 8526 Level 16: Cannot go remot
e
> while the session is enlisted in a distributed transaction that has an act
ive
> savepoint. I setup two sql server 2000 in two windows 2003 server, both
> install sql server sp1. I created linked server and setup MCDTC on both
> server. When I run application that include distributed transaction, I got
> error above. I re-check MCDTC, permission and so on, but I still got that
> issue. Could some one help me to fix it? Thanks in advance.
>|||Thank you very much. But for my case, the server is windows 2003 and have
already installed service pack 1. Is there something else that I need to
install? Thanks.
"Sreejith G" wrote:
[vbcol=seagreen]
> For more information about using trace flags and startup parameters, see t
he
> "DBCC TRACEON" and "Using Startup Options" topics in SQL Server 2000 Books
> Online.
> To use trace flag 8599, obtain the latest service pack for SQL Server 2000
:
> Q290211 INF: How to Obtain the Latest SQL Server 2000 Service Pack
> Once you update the service pack your problem will get fixed. Please updat
e
> the same and lemme know if it works...
> --
> Thanks,
> Sree
> [Please specify the version of Sql Server as we can save one thread an
d time
> asking back if its 2000 or 2005]
>
> "Iter" wrote:
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment