How Can I Download All Stored Procedures From a Specific Database | Blogz Den
Q: I have to download all stored procedures from a specific database. There are around 130 stored procedures, and I can do it manually like by doing save as a file each one. But is there any automatic option to download all ?
Ans: "Yes"
2) Select your database in the Object Explorer
3) Right click on Database > Tasks > Generate Scripts
4) Select only stored procedures to be scripted out.
4) Select only stored procedures to be scripted out.
a- you can select specific SPs as well by click on "+" button
5) Following the wizard through the steps; on the next screen, pick option "Single file per object" and define a directory where to put those files:
Post a Comment