We have an inventory function that accepts 3 parameters and returns one value. This function is used through out the program by several different stored procedures. We have a need to log some of these calls to this function. I tried using an insert command from within this function and I get this error…

“Only functions and extended stored procedures can be executed from within a function.”

Can you and how do you insert from within a function?