Yeah, there will be plenty of loops in this code.
I want to step through each SP, save its code to a file, pull out any
references to other SPs and save their code to the same directory. That's
all
-----Original Message-----
From: Steve Hughes
[mailto:mssqldba-ezmlmshield-x5465159.[Email address protected]
Sent: Tuesday, February 28, 2006 4:53 PM
To: LazyDBA Discussion
Subject: RE: text of an SP

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




---------------------------------------------------------------------
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