Saturday, December 22, 2007

Create SQL Query for all SPs


This is something that everybody knows but I dono.

How to take the backup of all the SPs in your DB and create it as a single query.

I know how to generate queries for individual SP but dint know how to do it for all.

This is how it should be done:

Open the Object Explorer and click on the Stored Procedure folder.

Then you should see a tab listing all the SPs in the right.

Click on all the SPs and right click then and save in a file.

The Screenshot above is not accurate this is taken from System Stored Procedures just to give an Idea.

No comments: