Only functions and extended stored procedures can be executed from within a function.You cannot execute user defined sotred procedures from a function.