Hello.
One of our database developers is running into a problem when trying
to get distributed transactions to work across linked servers. (SQL
2005 to SQL 2000).
The specific error message is:
"Msg 8501, Level 16, State 3, Procedure _Test2, Line 12 MSDTC on
server 'MSDB02' is unavailable."
I've check to confirm that the DTC service is running on both
machines. We've read over these article/discussions:
http://www.thescripts.com/forum/thread82878.html
http://www.google.com/search?q=MSDTC...is+unavailable
Any suggestions on what we can do to trouble-shoot this?
Thank you.