SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Old Forums
 CLOSED - General SQL Server
 Copy stored procedure
 Forum Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

LearnEveryDay
Starting Member

37 Posts

Posted - 09/15/2006 :  05:25:22  Show Profile
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)

Singapore
17650 Posts

Posted - 09/15/2006 :  05:32:11  Show Profile
use Enterprise Manager, select the stored procedure that you want right click and 'Generate SQL Script'


KH

Go to Top of Page

LearnEveryDay
Starting Member

37 Posts

Posted - 09/15/2006 :  05:46:39  Show Profile
Thanks - it made my work so easier.
Go to Top of Page

Kristen
Test

United Kingdom
22415 Posts

Posted - 09/15/2006 :  07:14:01  Show Profile
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 them

Kristen
Go to Top of Page
  Previous Topic Topic Next Topic  
 Forum Locked
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000