We experience the exact same scenario. SQL Server 7

Joel Patterson
Database Administrator
joel.[Email address protected]
x72546
904 727-2546

-----Original Message-----
From: Gord Debiasi
[mailto:mssqldba-ezmlmshield-x15267245.[Email address protected]
Sent: Wednesday, May 30, 2007 9:57 AM
To: LazyDBA Discussion
Subject: RE: DTS Logging

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




---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


MS Sql Server LazyDBA home page