I have over 100 Stored Procedures in my database and would like to know how to export them to text files as a backup? (Not the output data of the Stored Procedure, but the Stored Procedure itself.)
Please help! Thank you
Check uot SQLDMO is BOL.
It has scripting capabilities.
Sushila, Thanks a ton! I hadn't explored the option you mentioned.
It worked and I've gained more SQL knowledge. Thank U once again
for an instance you can do it other alternet way too use L:
sp_helptext 'yrspname' it will display the text / code of yr sp copy / save it to .txt file .