user-defined function & remote server
Posted on 2005-05-16
Hi all SQL SERVER Expert,
I've made a user-defined function that works fine on the server, but if I want to use it from a remote server it does not work and I get this error.
On the server that have the function this works good
select * from dbo.func_Serveur_Alias()
On another server that use a link server I tried this
select * from suivi.applications.dbo.func_Serveur_Alias()
And I get this error
Server : Msg 170, level 15, status 31, Line 1
Line 2: Incorrect syntax near '('.
PLEASE HELP ME !!!