"Michael" <michael@ihringer.de> wrote in message
news:002101c34a1b$511d1a20$a301280a@phx.gbl...
> Hi,
>
> instead of a pure linked server connection (which I have
> set up successfully already), I would need the
> functionality of liked tables (i.e. being able to access
> tables in regular, not 4-part syntax and get the access
> re-routed to the linked server).
>
> Is there any way of setting up table aliases or mappings
> that point to linked servers? (Views do not help because
> I need to process complex transactions that involve many
> tables.)
>
> Thanks for any suggestions,
>
> Michael

"Michael" <michael@ihringer.de> wrote in message
news:017b01c34a21$cf09ad80$a101280a@phx.gbl...
> That was also my obvious choice. Unfortunately, views
> won't do the (full) job because there are indexed tables
> in the linked database and I need the indexes (and other
> optimization logic in that other database) to be used.
>
> Thanks,
>
> Michael
>
> >-----Original Message-----
> >How about a view?
> >
> >John
> >
> >"Michael" <michael@ihringer.de> wrote in message
> >news:002101c34a1b$511d1a20$a301280a@phx.gbl...
> >> Hi,
> >>
> >> instead of a pure linked server connection (which I
> have
> >> set up successfully already), I would need the
> >> functionality of liked tables (i.e. being able to
> access
> >> tables in regular, not 4-part syntax and get the access
> >> re-routed to the linked server).
> >>
> >> Is there any way of setting up table aliases or
> mappings
> >> that point to linked servers? (Views do not help
> because
> >> I need to process complex transactions that involve
> many
> >> tables.)
> >>
> >> Thanks for any suggestions,
> >>
> >> Michael
> >
> >
> >.
> >

> instead of a pure linked server connection (which I have
> set up successfully already), I would need the
> functionality of liked tables (i.e. being able to access
> tables in regular, not 4-part syntax and get the access
> re-routed to the linked server).
>
> Is there any way of setting up table aliases or mappings
> that point to linked servers? (Views do not help because
> I need to process complex transactions that involve many
> tables.)