Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    149

    Unanswered: Accessing UDF on a linked server

    Hi all-

    I need to invoke a UDF on a linked server. Is this possible?

    eg:
    I need to execute the following query from Server1

    select *
    from Server2.Database.owner.fnGetTree() AS Server2Tree
    inner join Database.owner.fnGetTree() AS Server1Tree
    on Server1Tree.NodeId = Server2Tree.NodeId

    Thanks for your time

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    149
    Never mind. I got it. I could do this using OPNEQUERY

Posting Permissions

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