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
 General SQL Server Forums
 New to SQL Server Programming
 Import or export lots of sp

Author  Topic 

allan8964
Posting Yak Master

249 Posts

Posted - 2008-06-30 : 18:20:40
How can I copy (import or export) store procedures, or views, there are hundred of them, to other database? Thanks in advance.

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-06-30 : 18:23:54
Right click database-Tasks- Generate script - you can script there
Go to Top of Page

allan8964
Posting Yak Master

249 Posts

Posted - 2008-06-30 : 18:33:42
i tried it, it works perfect! thank you so much!
Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-06-30 : 22:12:29
You are welcome.
Go to Top of Page
   

- Advertisement -