UFN_TRANSLATIONFUNCTION_PAGEDEFINITION_GETNAME

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