Get ALL Procedures Using One Query

We can get get all procedure text using a single query in SQL Server.

Just run this query.

Select Object_Name(C.id) AS Name , text From SysComments AS C Left Join SysObjects AS O On C.id = O.id Where O.xtype = 'P'