X-Received: by 10.224.173.4 with SMTP id n4mr11241909qaz.3.1377131092431; Wed, 21 Aug 2013 17:24:52 -0700 (PDT)
X-Received: by 10.50.102.97 with SMTP id fn1mr555827igb.16.1377131092235; Wed, 21 Aug 2013 17:24:52 -0700 (PDT)
Path: csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!news.glorb.com!fx3no3932142qab.0!news-out.google.com!c19ni456qak.0!nntp.google.com!fx3no3932136qab.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
Newsgroups: comp.databases.ms-sqlserver
Date: Wed, 21 Aug 2013 17:24:51 -0700 (PDT)
In-Reply-To: <XnsA2235F17C935BYazorman@127.0.0.1>
Complaints-To: groups-abuse@google.com
Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=216.14.58.122; posting-account=PG2dbQkAAADVILsQ0GhgAM6hZK18SIjs
NNTP-Posting-Host: 216.14.58.122
References: <1c953ac5-0c12-4cfe-9c43-b688af51846e@googlegroups.com> <XnsA2235F17C935BYazorman@127.0.0.1>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <58e3fe4e-7e8d-4e9f-93ff-06ee37346b83@googlegroups.com>
Subject: Re: pitfalls of accessing linked server over WAN
From: migurus <migurus@yahoo.com>
Injection-Date: Thu, 22 Aug 2013 00:24:52 +0000
Content-Type: text/plain; charset=ISO-8859-1
Xref: csiph.com comp.databases.ms-sqlserver:1548

<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.
> 
> 
> 
> 
> 
> -- 
> 
> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Unfortunately we can not modify app