Kevin,

I use APEX SQL Diff tool to syncronize all objects(Tables, DPs, UDFs, etc) bettwen dev and produvtion.
I guess you can script SPs in dev and run script in production.


>My turn to ask a simple [if not stupid] question, hopefully I'll be the benefactor of the Sergey encyclopedia....
>
>There are a few dozen stored procs that I need to update from one database server to another [basically test and production]. What's the quickest and most painless way to refresh? I'm having a brain seizure right now. Thanks...