Re: 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 392,271 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,668 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: Sep 2006

Posts: 26

Reputation: chmonalisa is an unknown quantity at this point

Rep Power: 2

Solved Threads: 1

chmonalisa chmonalisa is offline

Offline

Light Poster

Re: Can we call a User defined Function using Linked Servers ?

Sep 14th, 2006

hey buddy,:lol:

first you need to add up the linked server

EXEC sp_addlinkedserver
@server = 'server1',
@srvproduct = '',
@provider = 'sqloledb',
@datasrc = 'LocalServer'

then
add linkedserverlogin

EXEC sp_addlinkedsrvlogin 'server1', 'true'

then write up the query as

[server1].Database.dbo.fn_test(@test).

reply me if u need further info.
Thanks,

Chaitanya.