Sunday, March 11, 2012

calling a function on a different server?

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