Lynn Pettis (5/20/2016)
Just curious, if clicking on Modify resulted in an error did anyone try clicking on Script Stored Procedure As, select Alter to, then select New Query Editor Window and see if that worked?
I just encountered this problem and tried every option: script create to Window, file, clipboard..... same with script alter
hot2use (12/22/2015)
.....The comments where located before the definition of the actual sproc, which seems to be bad practice.....hot2use
I think the problem I encountered is due to nested comments:
/* comment blah blah
/* nested comment, blah blah */
*/