
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:
Post a Comment