Gail,

Thanks for the suggestion, yes, whenever I checked the queryplan from the QA, the remote query always showed 100% cost.

However, I have one doubt. This remote query is invoked from...

Thanks Taj, Robert.

I wrote a piece of code as Taj suggested, but I believe Robert is correct, in a sense that in SQL 2000 a deadlock does terminate the process and the...

Thanks for the quick response. I guess you are quite accurate.

Sorry...The database is SQL2000

Thanks

Thanks for your response Bill. I was also guessing that we might just implement same version of MDAC on both