Wednesday, March 7, 2012

copy all the sps

I wanna copy all the stored procedures from one database to another database
throug stored procedure,
is there any ways?
Thanks
Why would you want to do this thru a stored procedure? In any case you can
use SQL-DMO thru sp_OAcreate. Have a look in BooksOnLine for more details.
Andrew J. Kelly SQL MVP
"Roger" <naissani@.hotmail.com> wrote in message
news:OpDEVHZVGHA.1160@.TK2MSFTNGP09.phx.gbl...
>I wanna copy all the stored procedures from one database to another
>database throug stored procedure,
> is there any ways?
> Thanks
>

No comments:

Post a Comment