Sounds like your stored procedure is making more modifications than there is room for the transaction log to record. If that's the case, rewrite the procedure so that it's more efficient. If that's not possible, you'll need to increase the size of your transaction log.

John