Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
miltongonsalves
Starting Member
3 Posts |
 Posted - 2007-05-02 : 11:27:44
|
| Folks:I need help on recreating all User Stored Procedures from One Database to Another on same server. I am using DTS "Copy SQL Server Object Task" and for some reason it is not copying the stored procedures. My Create destinaation Objects is NOT CHECKED.. If I Check that it also drops / recreates the destination tables which I don't want. In the "Copy all objects" I have selected the Objects (Stored Procedures Only. Anybody with similar kind of situation or is there a script which I can run to get all the stroed procedures on a databases and then I can use that output to recreate stored procedure on another database. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-02 : 14:16:44
|
| You can script them then run the script in other dbs. |
 |
|
|
miltongonsalves
Starting Member
3 Posts |
Posted - 2007-05-02 : 15:05:21
|
| Well, this has to be a ongoing stuff that's the reason I need a automated process/script.. |
|
|
|
|
|
|
Copy Only Stored Procedures?