C# / SQL Get all Stored Procedures and their Code

SELECT    sysobjects.name, syscomments.text
FROM    sysobjects
JOIN    syscomments
    ON    sysobjects.id = syscomments.id
WHERE    xtype='p'