SQL Server (2005) Linked Server Issue

Posted by David.Chu.ca on Stack Overflow See other posts from Stack Overflow or by David.Chu.ca
Published on 2009-08-12T17:11:30Z Indexed on 2010/12/22 4:54 UTC
Read the original article Hit count: 165

Filed under:

I have SQL Server 2005 with several linked server defined. One of them is a connection to an Oracle server and another one is an ODBC bridge to another server on a remote machine (ODBC server).

Recently I tried to use the linked server to Oracle to update data with two large size tables by using several joints. The update query took too long time and finally there was exception thrown:

   Update O set value = l.value
      FROM OracleServer..schema.largesizeTable O Join localLargeSizeTable l
      on ....

The problem is that after the exception, I realized that another linked server to ODBC was not working any more. I had to restart SQL server to get the ODBC linked server back. It looks that the linked server pool could be crashed if any of them failed(not like sandbox in Chrome for each tab and no impact on other tabs or Chrome application at all). I am not sure if my assumption is correct or not. Is this a known issue of SQL server 2005?

© Stack Overflow or respective owner

Related posts about sql

Related posts about sql-server-2005