POSTED AGAIN- DISTRIBUTED TRANSACTION

Hi,
I have two sql servers with SQL2000 service pack 3 which are linked by the
"Link Server". When i use the "begin tran" (distributed transaction) in
stored procedure, i am getting the following error.
"Server: Msg 8525, Level 16, State 1, Line 1
Distributed transaction completed. Either enlist this session in a new
transaction or the NULL transaction. "
The following article talks about this problem.
http://support.microsoft.com/?kbid=834849
But, both servers are SQL 2000 in my case. Any help?
Thanks,
VijayVijay,
Try rerun the same Instcat.sql described in the kb again on each node. This
will ensure that they have the correct catalog sprocs.
-oj
"Vijay" <vijay@.infosysusa.com> wrote in message
news:%23yRbv$LBFHA.1200@.tk2msftngp13.phx.gbl...
> Hi,
>
> I have two sql servers with SQL2000 service pack 3 which are linked by the
> "Link Server". When i use the "begin tran" (distributed transaction) in
> stored procedure, i am getting the following error.
>
> "Server: Msg 8525, Level 16, State 1, Line 1
> Distributed transaction completed. Either enlist this session in a new
> transaction or the NULL transaction. "
>
> The following article talks about this problem.
> http://support.microsoft.com/?kbid=834849
> But, both servers are SQL 2000 in my case. Any help?
>
> Thanks,
> Vijay
>
>|||I don't think so. It is working for other distributed queries. Any other
solutions please?
Thanks,
Vijay
"oj" <nospam_ojngo@.home.com> wrote in message
news:%23bSADGMBFHA.1076@.TK2MSFTNGP10.phx.gbl...
> Vijay,
> Try rerun the same Instcat.sql described in the kb again on each node.
This
> will ensure that they have the correct catalog sprocs.
> --
> -oj
>
> "Vijay" <vijay@.infosysusa.com> wrote in message
> news:%23yRbv$LBFHA.1200@.tk2msftngp13.phx.gbl...
the
>|||Vijay,
What do you mean "It is working for other distributed queries". If you only
encounter the error on enlisting a distributed transaction, I suggest you
take a look at your linkedserver logins. Also, check to make sure DTC
services are using proper accounts. If they're started under LocalSystem, it
will not have access to network resources. If you are going to make any
changes to your DTC services, you will have to restart SQL server for it to
takes effect.
-oj
"Vijay" <vijay@.infosysusa.com> wrote in message
news:eKKqhVMBFHA.1992@.TK2MSFTNGP10.phx.gbl...
>I don't think so. It is working for other distributed queries. Any other
> solutions please?
> Thanks,
> Vijay
> "oj" <nospam_ojngo@.home.com> wrote in message
> news:%23bSADGMBFHA.1076@.TK2MSFTNGP10.phx.gbl...
> This
> the
>

Post upgrading question

I have moved my SQL 7.0 to a brand new machine with SQL
2000 using the copy database Wizard. however it seems to
be too slow now. Does anyone know what I can do to speed
this up? Should I do anything particulary after upgrading.
Thanks for any help -RobOne thing is sp_updatestats.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Rob" <rob@.nul.ca> wrote in message
news:f1ba01c40c37$363f7700$a101280a@.phx.gbl...
> I have moved my SQL 7.0 to a brand new machine with SQL
> 2000 using the copy database Wizard. however it seems to
> be too slow now. Does anyone know what I can do to speed
> this up? Should I do anything particulary after upgrading.
> Thanks for any help -Rob|||Hi Rob,
I agree with Tibor. Also, I'm including some supplemental information below:
319942 HOW TO: Determine Proper SQL Server Configuration Settings
http://support.microsoft.com/?id=319942
298475 HOW TO: Troubleshoot Application Performance Issues
http://support.microsoft.com/?id=298475
243589 HOW TO: Troubleshoot Slow-Running Queries on SQL Server 7.0 or Later
http://support.microsoft.com/?id=243589
243588 HOW TO: Troubleshoot the Performance of Ad-Hoc Queries
http://support.microsoft.com/?id=243588
HOW TO: Troubleshoot Application Performance with SQL Server
http://support.microsoft.com/?id=224587
Please try the suggestions in the above articles, which will help you
troubleshoot the performance issue of SQL Server.
Regards,
Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.