List all the Stored Procedures of a Database and their Definitions using T-SQL in SQL Server 2005/2008
SELECT obj.Name as SPName,
modu.definition as SPDefinition,
obj.create_date as SPCreationDate
FROM sys.sql_modules modu
INNER JOIN sys.objects obj
ON modu.object_id = obj.object_id
WHERE obj.type = ‘P’
