I want to know how to get or copy all the store procedures to a local directory.
I am able to extract and copy one by one. Right click on a store procedure name and then click on extract and say file-> save as to my local folder. But I have more than 100 store procedures so I need to know if there is any easier way so that I can save all of the store procedures in a batch. Please let me know if there is any nice way of doing it.
Thanks in advance.