Embed that in a loop that queries the sysobjects table for procedures.

-Steve Hughes

-----Original Message-----
From: Jay Butler
[mailto:mssqldba-ezmlmshield-x59005486.[Email address protected]
Sent: Tuesday, February 28, 2006 3:45 PM
To: LazyDBA Discussion
Subject: Re: text of an SP

execute sp_helptext procedure_name

Mordechai Danielov wrote:
> Facing a code review, I am looking to get the text of my stored
procedures
> without having to go into each one of them. Does anybody know a table
I can
> query, or have other suggestions?
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> Website : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



MS Sql Server LazyDBA home page