By joining sysobject and syscomments table we can get your desired results,
run this query in Query Analyzer (with result in text mode)....
-----------------------------------------------------------------------------
SELECT dbo.syscomments.text, dbo.sysobjects.name
FROM dbo.syscomments INNER JOIN
dbo.sysobjects ON dbo.syscomments.id = dbo.sysobjects.id
WHERE (dbo.sysobjects.xtype = 'p')
-----------------------------------------------------------------------------