MSSQL: Get Stored Procs and Stored Proc Code From DB

gistfile1.txt

select OBJECT_SCHEMA_NAME ( a.object_id) + '.' + a.name
,OBJECT_SCHEMA_NAME ( a.object_id) as [schema]
,OBJECT_DEFINITION(a.object_id) as def
from
sys.all_objects a
where a.type_desc = 'SQL_STORED_PROCEDURE'
and a.name not like 'sp_%'
and a.name not like 'xp_%'