I often copy paste the output of “sp_helptext” for some of our stored procedures. For whatever reason, they often paste with numerous blank lines between each meaningful section of code. Here is how I get rid of those lines:
Get rid of blank lines in SSMS
Published
Justin Onstot 