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 WHEREid = (SELECTidFROM sysobjects WHERE name = so.name) ) sps WHEREtype = 'P' ANDcategory = 0 ORDERBY name