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’

Be Sociable, Share!

•