Call User Defined Functions in Linked Server

User defined functions cannot be called on Linked Server.

To work around this problem, use the Openquery function instead of the four-part naming convention.

You need to create following function in your DB where Linked Server needs to call.

CREATE FUNCTION [dbo].Function_Name(@Parameter INT)

RETURNS VARCHAR(8000)

AS

BEGIN

DECLARE @word sysname

EXEC LinkedServer.DatabaseName.dbo.sp_executesql

N'SELECT DatabaseName.dbo.Function_Name(@Parameter)' --dynamic sql query to execute

,N'@Parameter int' --parameter definitions

,@Parameter=@word OUTPUT --assigning the caller procs local variable to the dynamic parameter

RETURN @word

END

For more details, kindly visit the link below.

http://developersmania.blogspot.com/2012/11/call-user-defined-function-on-linked.html[^]

I hope this helps you.