Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Copy Stored Procs from database to another?
Message
 
To
18/04/2008 00:31:03
General information
Forum:
ASP.NET
Category:
Databases
Miscellaneous
Thread ID:
01311618
Message ID:
01311637
Views:
15
>How can I copy a group of (or all) stored procs from SQL Server database to another?

You can do this via SQL Server Management Studio. Right-click on the Database, select Tasks, then Generate Scripts. A wizard will open, select the database, hit next, select whatever options you want, click next and check the option to just generate Stored Procs. Select the procs. you want (or all of them), and save it. Then rerun this script on your other database.
-Paul

RCS Solutions, Inc.
Blog
Twitter
Previous
Reply
Map
View

Click here to load this message in the networking platform