Export all stored procedures

You can extract the definitions of all stored procedures with this simple script.

select m.definition
from
    sys.objects as o
    inner join
        sys.sql_modules as m
            on o.object_id = m.object_id
where
    o.type = 'p'