Copy Stored Procedures From 1 Database to Another Using Query

why are you set on using QA for this?
why not use DTS from Enterprise Manager? that would be much easier, as
you can do all of them at once.
you can do it from QA, but it would have to be done one at a time, e.g.
* open the object explorer
* expand your WebCentral database \ Stored Procedures
* right-click on the proc to copy
* select "Script Object to new window as \ [ Create | Alter ]" (create
or alter depending on if it's in the WebPPO database already)
* in the new window that pops up, switch to the WebPPO database using
the database drop-down, or the Ctrl+U dialog
* execute the query
RitaG wrote:
> Hi.
> I have some Stored Procedures (SPs) in one database (WebCentral).
> I have a table in another database (WebPPO) that holds the names of
> databases that I want to copy SPs from WebCentral to.
> I want to copy these SPs via code within Query Analyzer but have no idea h
ow
> to accomplish this.
> Any suggestions would be greatly appreciated!
> Thanks,
> Rita
>Hi Trey.
Thanks for the response.
I tested out using a DTS package and that worked well - thank you.
The only reason I would have preferred to use QA is so that it could be
executed dynamically. If another database was added that needed a copy of th
e
SPs then I wouldn't have to change the DTS package.
I'll play around with your suggestions on how to use QA and see if I can
come up with something.
Thanks,
Rita
"Trey Walpole" wrote:

> why are you set on using QA for this?
> why not use DTS from Enterprise Manager? that would be much easier, as
> you can do all of them at once.
> you can do it from QA, but it would have to be done one at a time, e.g.
> * open the object explorer
> * expand your WebCentral database \ Stored Procedures
> * right-click on the proc to copy
> * select "Script Object to new window as \ [ Create | Alter ]" (create
> or alter depending on if it's in the WebPPO database already)
> * in the new window that pops up, switch to the WebPPO database using
> the database drop-down, or the Ctrl+U dialog
> * execute the query
>
> RitaG wrote:
>