UDF on a Linked Server

• mromm

  SSCarpal Tunnel

  Points: 4301

  More actions

  July 24, 2003 at 11:58 am

  #80758

  Is there a strait-forward way to call a UDF on a linked server? The following statement does not work:

  select * from server_name.database_name.dbo.udf_name( 1 )

  However the same statement without the server name works fine:

  select * from database_name.dbo.udf_name( 1 )

  If it is not possible to specify the server name here, what is the logical reasoning for it?

  Thank you.

  Michael

• Allen Cui-55137

  SSC Guru

  Points: 51650

  More actions

  July 24, 2003 at 12:09 pm

  #466894

  Have you tried to use openquery to call function in linked SQL Server.

  For example,

  select * from OPENQUERY(TSTSQL01,'select * from master.dbo.usysprocess(51)')

• mromm

  SSCarpal Tunnel

  Points: 4301

  More actions

  July 24, 2003 at 12:11 pm

  #466895

  Allen, you are right. It works that way. Thank you.

• mromm

  SSCarpal Tunnel

  Points: 4301

  More actions

  July 24, 2003 at 12:16 pm

  #466896

  I just wonder if using UDF is better than using a SP on the linked server. The SP would return a rowset, of course, that would be inserted into a local temp table. OR use a UDF and still insert into a local temp temp for further usage.

  So, does anyone have experience of comparing performance of these approaches?

  Thank you.

  Michael