Can we call a User defined Function using Linked Servers ?

•

What is DaniWeb IT Discussion Community?

You're currently browsing the MS SQL section within the Web Development category of DaniWeb, a massive community of 391,616 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,629 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our MS SQL advertiser:

Can we call a User defined Function using Linked Servers ?

•

Join Date: Aug 2006

Posts: 1

Reputation: aiosilver is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

aiosilver

Offline

Newbie Poster

Can we call a User defined Function using Linked Servers ?

Aug 3rd, 2006

I cant call :
[111.111.111.1].Database.dbo.fn_test(@test) (Not working !)
but i can call :
Database.dbo.fn_test(@test)
why ?

and if no way to call this, can i populate in a function
a TABLE variable using a Stored Procedure to do this ?

CREATE FUNCTION fn_test(@idcode int,@idoper int)
RETURNS TABLE
AS
RETURN (EXEC [111.111.111.1].Database.dbo.sp_populate)
Not working !
Thanks for your help