How to access UDF across servers!
It seems that this is not possible by using the standard server linkage: ServerName.db.dbo.
This is because you cant qualify the server in a UDF. However to get round this the UDF can be called from the remote server using in sp_executesql.
It is also possible to create a SP on the remote server to handle the call.
It seems that this is not possible by using the standard server linkage: ServerName.db.dbo.
This is because you cant qualify the server in a UDF. However to get round this the UDF can be called from the remote server using in sp_executesql.
It is also possible to create a SP on the remote server to handle the call.
No comments:
Post a Comment