I have a piece of code with a ton of headers, including the initial "if exists drop" and a sample call.
If I type "exec myprocnamehere", the box pops up with the actual script text. I can then click in the box, hit "copy", and paste in a window.
If I type ALTER PROCEDURE myprocnamehere, then hit TAB, the SP scripts otu - but only starting at the actual ALTER PROCEDURE line, it doesn't include the header! So if I execute it, I'd lose my script headers.
Is there a way to change the behavior? Is there an easier way to script out the object (either way is tons easier than SSMS, but I'd moved to AP (tab) code (tab) and use the snippets to quickly script out the code.