Select all Stored Procedures with their parameters

SELECT s.[name], s2.[name], s2.type, s2.length, s2.colorder, s3.[name]
FROM sysobjects s
LEFT JOIN syscolumns s2 ON s.id = s2.id
LEFT JOIN systypes s3 ON s3.[xusertype] = s2.xusertype
WHERE s.[type] = 'P' AND s.category = 0
ORDER BY s.[name], s2.colorder