• I would change query a little

    select 'DROP PROCEDURE ['+ si.name + '].[' + so.name + ']'+ CHAR(13)+CHAR(10)+'GO'+CHAR(13)+CHAR(10)+

    OBJECT_DEFINITION(object_id)+ CHAR(13)+CHAR(10)+'GO'+CHAR(13)+CHAR(10)

    from sys.objects so inner join sys.schemas si ON so.schema_id = si.schema_id

    where so.type='P'

    1. Add brackets to procedure name if proc name is "non standard"

    2. Add join with sys.schemas for procedures not in dbo/current user schema