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 |
|
malikjaved
Starting Member
21 Posts |
 Posted - 2008-01-30 : 12:29:29
|
| HI Guys.acutally i m trying to get help in copy of some stuff like Store Procedure from one server database to another Server Database, manually i can do it, copy and paste like .. but is there any code or script that can handy for me ?Thanks and looking forwad.-MALIK |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2008-01-30 : 20:46:21
|
script out the Stored Procedure using SSMS and apply it at the target database
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
malikjaved
Starting Member
21 Posts |
Posted - 2008-01-31 : 03:44:32
|
| Thanks for reply, but i m not looking for doing like this, i want to done by this all by using a store procedure. i have write the script that will let me know the certain store procedure that has been modified in certain date and time but now the problem i m faceing how to copy over to other server database, i can easly doing copy store procedure from one database to other database but only one server like this [databaseName].[dbo].create or alter procedure.Thanks and looking forward.-MALIK |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-01-31 : 03:56:55
|
| Try using Transfer SQL Server objects task in SSIS |
|
|
|
|
|
|
Copy Store procedure to another Server database