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 timeNever mind. I got it. I could do this using OPNEQUERY
No comments:
Post a Comment