Groups > comp.databases.ms-sqlserver > #1551

Re: pitfalls of accessing linked server over WAN

From	Erland Sommarskog <esquel@sommarskog.se>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: pitfalls of accessing linked server over WAN
Date	2013-08-22 08:48 +0000
Organization	Erland Sommarskog
Message-ID	<XnsA2246DF5A3D83Yazorman@127.0.0.1> (permalink)
References	<1c953ac5-0c12-4cfe-9c43-b688af51846e@googlegroups.com> <XnsA2235F17C935BYazorman@127.0.0.1> <58e3fe4e-7e8d-4e9f-93ff-06ee37346b83@googlegroups.com>

Show all headers | View raw

migurus (migurus@yahoo.com) writes:
><snip>
>> you should test that your code behaves as expected. For a simple
>> procedure 
>> 
>> like this one, I would recommend that you open a direct connection 
>> 
>> from the application instead.
>> 
>> 
> 
> Unfortunately we can not modify app
> 

Why not? Apparently you can fiddle with it so much that you can add a new
stored procedures. 

Of course, if this is a third-party application for which you don't have the
source code, I see that it is difficult. But does the license for the 
application permit you to put tables on remote servers?

The point is that the solution you are looking at will give you headache, 
and I pointed you to a simpler solution.

Two more options:

1) Rather than using a linked server, use a CLR stored procedure where you 
habe more control over the connection string and set a short connection 
timeout, and where you more easily can trap errors.

2) Replicate the table from the remote server to the local server.

-- 
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

pitfalls of accessing linked server over WAN migurus <migurus@yahoo.com> - 2013-08-20 18:31 -0700
  Re: pitfalls of accessing linked server over WAN Erland Sommarskog <esquel@sommarskog.se> - 2013-08-21 07:20 +0000
    Re: pitfalls of accessing linked server over WAN migurus <migurus@yahoo.com> - 2013-08-21 17:24 -0700
      Re: pitfalls of accessing linked server over WAN Erland Sommarskog <esquel@sommarskog.se> - 2013-08-22 08:48 +0000
  Re: pitfalls of accessing linked server over WAN Lutz <news@invalid.invalid> - 2013-08-21 10:02 +0200
    Re: pitfalls of accessing linked server over WAN migurus <migurus@yahoo.com> - 2013-08-21 17:21 -0700
      Re: pitfalls of accessing linked server over WAN Lutz <news@invalid.invalid> - 2013-08-22 08:47 +0200
        Re: pitfalls of accessing linked server over WAN bradbury9 <ray.bradbury9@gmail.com> - 2013-08-22 00:10 -0700
        Re: pitfalls of accessing linked server over WAN migurus <migurus@yahoo.com> - 2013-08-22 11:32 -0700

csiph-web