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.

 All Forums
 SQL Server 2005 Forums
 Other SQL Server Topics (2005)
 How to copy Sp one Db to another DB

Author  Topic 

ssmani84
Starting Member

20 Posts

Posted - 2010-03-05 : 04:18:23

how to copy the one or more sp in one DB to Another DB at a time

ssmaniyadav

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2010-03-05 : 04:23:27
One method is to take a script of the SPs from one DB and run them in another DB

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

surenv2003
Starting Member

3 Posts

Posted - 2010-03-05 : 08:19:56
That is the best and esiest method

Link Exchange with fun blog?http://finestmail.blogspot.com
Go to Top of Page
   

- Advertisement -