Is it possible to build a TRUE system udf and/or sp? I'd like to create a few basic functions (TRIM and TRUNC, for example) that can be called by any user of any database on the server without the full object path (FN_TRIM () instead of db.dbo.FN_TRIM() ).
Is there any way to do this? I've created a version on the master table under the system_function_schema owner, but that only allows me to use the functions universally if I'm logged in as a sysadmin. I'd like low level users to be able to execute queries that contain these functions.
Can this be done? I can't seem to find any information about it anywhere.