A stored procedure is executing (Error 1538)

You have attempted to recompile or unload stored procedures (for example, MODIFY PROCEDURE or CLOSE DATABASES) while in the middle of executing a stored procedure. This is an invalid operation.