UFN_TRANSLATIONFUNCTION_IDMAPPER_GETNAME

            create function dbo.UFN_TRANSLATIONFUNCTION_IDMAPPER_GETNAME(@ID uniqueidentifier) returns nvarchar(60) 
            with execute as caller
            AS
            BEGIN
                declare @NAME nvarchar(60)
                select @NAME = NAME from dbo.IDMAPPERCATALOG where ID = @ID
                return @NAME
            END