Trying to write a function that doesn't require dbo. prefix I am trying to write a simple system function so that the dbo. prefix is NOT required to access the function. I have found an example of this for SQL Server 2000 but when I run 

EXEC SP_CONFIGURE 'ALLOW UPDATES', 1
RECONFIGURE WITH OVERRIDE
go

create function system_function_schema.trim
    (@input varchar(max))
    returns  varchar(max)
as
begin
    declare @result varchar(max)

    select  @result = rtrim(ltrim(@input))

    return  @result
end
go

EXEC SP_CONFIGURE 'ALLOW UPDATES', 0
RECONFIGURE WITH OVERRIDE


This is the error thrown.


  The specified schema name "system_function_schema" either does not exist or you 
  do not have permission to use it. Severity 16


The expected usage would be

select trim('   padded value   ')


Does anyone know the approach I should be taking or if I HAVE to create it as a regular user defined function that must be called with the dbo. like : 

select dbo.trim('   padded value   ')
Using system_function_schema was an undocumented and unsupported process in SQL 2000. As of SQL 2005, it is no longer possible.

By design, UDFs require that the schema be included in the function call.

There is one exception: calling the function like a procedure doesn't actually require the schema, but also wouldn't be terribly useful for your function.

exec trim @input = ' foo '


Additionally, be sure to carefully test queries with scalar functions--they can have significant impact on performance.