SQL - Extract all user created Stored procedure text from syscomments

Post date: May 31, 2011 12:11:48 PM

SELECT text FROM sysobjects so CROSS APPLY ( SELECT text FROM syscomments WHERE id = (SELECT id FROM sysobjects WHERE name = so.name) ) sps WHERE type = 'P' AND category = 0 ORDER BY name