Hi Adi,

I tried that before and got another error message.

DECLARE @Handle binary(20)

select @Handle= sql_handle FROM master.dbo.sysprocesses

SELECT (SELECT TEXT FROM ::fn_get_sql(@Handle)) AS SQL_Command,

loginame, spid, dbid, cpu, physical_io, memusage, last_batch, status, hostname,...

Never mind... I found the problem and the solution.

Thanks anyway,

Oz

No one knows?!

There must be a solution for creating Synonyms on functions.

:ermm: