Friday, March 30, 2012

Linked server query

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