The other option is to add sprocs on the main server to bridge the gap. No
Gregory A. Beamer
"WenYuan Wang [MSFT]" <v-wywang@online.microsoft.com> wrote in message
news:SsjnOU8hHHA.5272@TK2MSFTNGHUB02.phx.gbl...
> Hi Michael,
> As far as I know, we can access data on a linked server through ADO.NET by
> the OpenQuery syntax. Do you meet any further issue on this? Please let me
> know and I'll follow up.
>
> Have a great day,
> Sincerely,
> Wen Yuan
> Microsoft Online Community Support
> ==================================================
> Get notification to my posts through email? Please refer to
>
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif > ications.
>
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
>
http://msdn.microsoft.com/subscriptions/support/default.aspx. > ==================================================
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>