I was wondering if anyone knows the best way to call a function that is located in database on a different server then the database that is calling the function. Is it possible to do this with out linked servers? I am running SQL Server 2000. Any help in this matter would be greatly appreciated.
You can't use four part names to run function from a different server. However, You can use OpenQuery for Linkedserver to do the same
Select * from OpenQuery(LinkedServer , 'Select MyRemoteDB.dbo.udfFunction ( ''Parameter'' )')
No comments:
Post a Comment