My goal here is to create a scripted text file that can be used on another server to create the same stored procedures. I have been using sp_helptext to script out the create statement, but every method I have used to create the script file results in something different, and unusable.
I know I can create using save results to file in QA and then pull the .rpt into QA from another server, that works fine. However, I need to automate this and I do not get the same results from DTS... the text file is full of garbage, or fails due to characters.
Hoping someone can get me pointed back in the right direction on this! Thanks!