Kids,

Try this: it will print all your SPs text. I just modified the original query from the article to include OBJECT_DEFINITION function. You have to set Query Results In Text to use it.

SELECT '--*****************************************'

+Char(13)+Char(10)+ '--'+Char(9) +Name

+Char(13)+Char(10)+ '--'

+Char(13)+Char(10)

+'--*****************************************'

+Char(13)+Char(10)+ '--'

,OBJECT_DEFINITION ( object_id (name))

FROM sys.all_objects

WHERE ([type] = 'P' OR [type] = 'X' OR [type] = 'PC')

ORDER BY [name];

GO