glenn hulls

run properly and i can see the objects in sysobjects -
type = 'FN'. How do i execute the functions ??

I have been trying the following but i keep getting
an error saying that 'function()' is not a recognised
function - any ideas ?

thanks in advance,
Glenn.

select @oldrow = f_get_old_row ( @this_row )

vishal parkar

Glenn,

When invoking scalar user defined function use minimum two-part name of the function ie "owner" and
"function name"
Ex
select owner_name.function_name (parm1,para.2....)

Whereas Table-valued functions can be invoked using a single part name.
Ex:
select * from function_name (parm1,para.2....)

System table functions that are included in SQL Server 2000 can be invoked by using a '::' prefix
before the function name.
Ex:

SELECT *
FROM ::fn_helpcollations()

--
- Vishal

nigel rivett

When calling a function you need to include the owner name

select @oldrow = dbo.f_get_old_row ( @this_row )