>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...
>
>Kevin
I would script them all, add a "use newDatabase" at top and execute in SSMS.
Update: You already solved:)
Cetin