UFN_SMARTQUERY_GETID

        create function dbo.UFN_SMARTQUERY_GETID (
            @NAME nvarchar(60))
        returns uniqueidentifier
        with execute as caller
        as
        begin
            declare @return_value uniqueidentifier
            select @return_value=ID from dbo.SMARTQUERYCATALOG where [NAME] = @NAME
            return @return_value
        end