function and linked server

[Marek Wierzbicki]

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

[Simon Hayes]

"Marek Wierzbicki" <ma******************@azymut.pl> wrote in message
news:bv**********@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

[Marek Wierzbicki]

> > 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

[Marek Wierzbicki]

> > 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