SQL 2008 R2 - Using a linkedServer when calling a user defined function

• cheshirefox

  Hall of Fame

  Points: 3464

  More actions

  March 25, 2011 at 1:47 pm

  #233773

  SQL 2008 R2 Enterprise.

  Trying to determine the best way to call a UDF using a linked Server.

  Any information you can provide is appreciated.

  Thanks in advance.

• cheshirefox

  Hall of Fame

  Points: 3464

  More actions

  March 25, 2011 at 2:45 pm

  #1303882

  Just an update.

  declare @b-2 varchar(200)

  declare @value varchar(10)

  set @value = 'w1w 5pa'

  EXEC @b-2 = LinkedServerName.DBNAME.dbo.FunctionName @value

  select @b-2

• Orlando Colamatteo

  SSC Guru

  Points: 182293

  More actions

  March 25, 2011 at 3:24 pm

  #1303890

  Cool. On my system the Linked Server "rpc out" property option had to be True for it to work:

  EXEC master.dbo.sp_serveroption

  @server=N'linked_server_name',

  @optname=N'rpc out',

  @optvalue=N'true'

  GO

  There are no special teachers of virtue, because virtue is taught by the whole community.
  --Plato