>I need to copy the stored procs from one database into another programmatically. Of course, I need to remove the existing stored procs from the destination DVC first. This is easy to do with the GUI but, does anyone know of commands to do it with a program?
John,
APPEND PROCEDURES has an OVERWRITE keyword. This should work for you.
HTH.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao