I have my own function, which I can use:

declare @dt as datetime
select @dt='20040121 12:22:33'
select * from index_gold_iif(@dt)

When I try do it from linked serwer:

declare @dt as datetime
select @dt='20040121 12:22:33'select * from
lewiatan.e_.dbo.index_gold_iif(@dt)

I have massage:
Server: Msg 170, Level 15, State 31, Line 2
Line 4: Incorrect syntax near '('.

Did server can't see function from linked server? Is it true or I have done
some error (what)?

Marek

PS. all done as "sa" user, linked server linked with sa account

"Marek Wierzbicki" <marek.wierzbicki.___@azymut.pl> wrote in message
news:bv39u8$g4g$1@news2.ipartners.pl...
> I have my own function, which I can use:
>
> declare @dt as datetime
> select @dt='20040121 12:22:33'
> select * from index_gold_iif(@dt)
>
> When I try do it from linked serwer:
>
> declare @dt as datetime
> select @dt='20040121 12:22:33'select * from
> lewiatan.e_.dbo.index_gold_iif(@dt)
>
> I have massage:
> Server: Msg 170, Level 15, State 31, Line 2
> Line 4: Incorrect syntax near '('.
>
> Did server can't see function from linked server? Is it true or I have
done
> some error (what)?
>
> Marek
>
> PS. all done as "sa" user, linked server linked with sa account
>
>
>

UDFs aren't supported directly on linked servers, but you can use
OPENQUERY() as a workaround:

http://support.microsoft.com/default...;en-us;Q319138

Simon

> > declare @dt as datetime
> > select @dt='20040121 12:22:33'
> > select * from index_gold_iif(@dt)

> UDFs aren't supported directly on linked servers, but you can use
> OPENQUERY() as a workaround:
>
> http://support.microsoft.com/default...;en-us;Q319138

both of them isn't good, beacouse my function return table (there is "view
with parametr")

Marek

> > UDFs aren't supported directly on linked servers, but you can use
> > OPENQUERY() as a workaround:
> >
> > http://support.microsoft.com/default...;en-us;Q319138

OK works for function returned table

Marek