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 |
|
LearnEveryDay
Starting Member
37 Posts |
 Posted - 2006-09-15 : 05:25:22
|
| Hi,I would like to copy all my stored procedure to my hard drive.I know how to save a single stored procedure. But I have more than 100 sps. Is there any way I can copy all the stored procedure at one go?Thanks, |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-09-15 : 05:32:11
|
use Enterprise Manager, select the stored procedure that you want right click and 'Generate SQL Script'
KH |
 |
|
|
LearnEveryDay
Starting Member
37 Posts |
Posted - 2006-09-15 : 05:46:39
|
| Thanks - it made my work so easier. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-09-15 : 07:14:01
|
| On 'Generate SQL Script' there is an option to "generate one file per object" which would get each of your Sprocs into a separate file - rather than one big "build script" for all of themKristen |
|
|
|
|
|
|
Copy stored procedure