can anybody please tell me how to query a table from a linked server?
thanks
Sure, thats quite easy, use the four part notation:
SELECT <columnlist> FROM LinkedServerName.DatabaseName.Owner.Objectname
HTH, Jens Suessmeyer.
No comments:
Post a Comment