UDF on linked server. - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

UDF on linked server.

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-03-27 : 11:18:18

Rocco writes "Hi All.
does anybody know if/how is possible to call an UDF that is on a linked
server?
I know that it is possible for stored procedures.
thanks a lot.
r,"

ToddV
Posting Yak Master

218 Posts

Posted - 2002-03-28 : 09:15:18

quote:

Rocco writes "Hi All.
does anybody know if/how is possible to call an UDF that is on a linked
server?
I know that it is possible for stored procedures.
thanks a lot.
r,"

It stands to reason that you can simply use the four-part name. I have not tried though.

roccopasca
Starting Member

1 Post

Posted - 2002-04-05 : 05:45:34

on server pascar, database prova, user dbo I have the UDF fn_test() that simply return the word 'Test'

If I do
select dbo.fn_test()
or select prova.dbo.fn_test()
It's all ok,

but if I do
select fn_test()
I have the following error:
Server: Msg 195, Level 15, State 10, Line 1
'fn_test' is not a recognized function name.
(I am user dbo)

Instead, if I do
select pascar.prova.dbo.fn_test()
I have the following error:
Server: Msg 117, Level 15, State 1, Line 1
The object name 'pascar.prova.dbo.' contains more than the maximum number of prefixes. The maximum is 2.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources