Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 384
  • Last Modified:

How do I export all of my stored procedures at once?

A client is creating a database that was created on my machine using the dbo.aspnet forms authentication tables and stored procedures. They currently have all the tables and the data in the tables how ever I've forgotten to get them the stored procedures that are created when .NET creates the aspnet tables and stored procedures that go with them. How can I quickly get all of the storprecedures to my client? Or do I have to copy and past them into a file, one at a time and send that? In other words, is that my only way of doing this?


Also, I noticed, in the "Stored Procedures" directory, that there is a sub set of stored procedures, in its own directory name "System Stored Procedures". Do I need those as well? And is there a particular order that the two groups of stored procedures need to be created in?
0
Michael Sterling
Asked:
Michael Sterling
  • 2
  • 2
3 Solutions
 
Simone BSenior E-Commerce AnalystCommented:
Right click on the database where the procedures are located, and select Generate Scripts. This opens a wizard where you can select what you want scripted. Just select what you need from each prompt. Including select Stored Procedures from the Choose Object Types window. You can choose to create a script file, which you can then attach and send via email.

You shouldn't need the system sp's. They can be found in every SQL database.
0
 
Chris LuttrellSenior Database ArchitectCommented:
In Management Studio, from the View Menu at the top go to Object Exporer Details and drill down to the Stored Procedure folder.  Then select all those you want together and right click and select Script Stored Procedure As ==> Create To ==> File Scripting_SP_to_File
0
 
Michael SterlingWeb Applications DeveloperAuthor Commented:
@CGLuttrell: How do you select multiple strored procs at once? Shift + Click and Ctrl + Click don't work. Or are you saying that I just need to put all of them, individually, one at a time, in the same file? If so, that works but, I was hoping to be able to do it all in one or two clicks.
0
 
Chris LuttrellSenior Database ArchitectCommented:
Object_Explorer_DetailsYou have to be in the Object Explorer Details window not the normal Object Explorer window that is the normal one on the left.  It will be bigger and where the querey window normally appears.
0
 
Michael SterlingWeb Applications DeveloperAuthor Commented:
Thank you.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now