See Can a Form be moved to another database? which deals with copying forms - do the same with procedures.