I have a need to query both the local and remote servers and union the results as a view. Is it possible to do this with a UDF? Basically the end result that I want is:
Select * from table
remote_query(Select * from table)
I don't need to pass remote server info this will be somewhat static during a migration period.