I have a bunch of stored procedure names. I want to export the create script for each of the stored procedure. What is the best way to do it?
Right now I am manually selecting the stored proc in SSMS and selecting "Script stored procedure as -> Drop and Create to". This seems tedious. I am hoping there is a better way to deal with this. Thanks.