Here is a confusing one......

SQL 2000 linked server issue. I have established a linked server
connection to a MySQL, and DB2 database. The connection will run for
three, four, five runs of a DTS, and then out of nowhere, just hang. At
the point, I can not view the tables in the connection, and I can not
stop the hanged process. The only solution to date has been to restart
the SQL Service. However, in our production environment, this is not an
easy task, nor a desired one. Any suggestions would be much appreciated.

By the way, we are running service pack 3 with plans to upgrade to 4.
However, I find it hard to believe this is an issue.

Thanks



MS Sql Server LazyDBA home page