I use EM for two functions that I do quite often, creating databases and scripting store procedures.

I know that it is fairly simple to create a db in TSQL, I just got in the habit of doing it through EM.

Scripting store procedures, on the other hand, is another story. I don't know of anyway to script a store procedure from TSQL, scripting it to the point of being able to cut/paste into QA to modify the procedure. sp_helptext does not help because it puts carriage returns in inappropriate places.

Is there a way to script a store procedure in TSQL?