Results 1 to 3 of 3

Thread: Linked Server

  1. #1
    Join Date
    Oct 2005
    Posts
    58

    Unanswered: Linked Server

    What is the syntax for querying through a linked server without usiing openquery?
    ie.
    LinkedServer.Database.owner.table ????

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    Yes, exactly that.
    Paul

  3. #3
    Join Date
    Nov 2005
    Location
    San Francisco, CA
    Posts
    506
    Quote Originally Posted by asahi
    What is the syntax for querying through a linked server without usiing openquery?
    ie.
    LinkedServer.Database.owner.table ????
    Yes,

    Code:
    SELECT CustomerID
              ,CompanyName
    FROM LinkedServer.Northwind.dbo.Customers
    Success is the ability to go from one failure to another with no loss of enthusiasm.
    - Sir Winston Churchill
    Joydeep

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •