• Restore a backup copy of the database and extract the correct procedure from that copy.

    You could set up a DDL trigger to capture this kind of changes into a table.

    Unfortunately, setting it up now that the damage is done won't help, but will save the pain next time it happens.

    -- Gianluca Sartori