[dba-SQLServer] Walk the lists of sprocs and udfs

I typically just use the object browser (F4) in QA to find the sprocs /
functions I need.

On 2/26/06, Arthur Fuller <artful at rogers.com> wrote:
>
> I want to walk the list of stored procedures and UDFs within a given
> database, using TSQL, and let's say print their names. Anyone know how to
> do
> that?
> Once I figure out how to do that, I then want to grab the source code for
> each sproc/udf and apply a Regex to it.
> TIA,
> Arthur
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>


--
-Francisco
http://pcthis.blogspot.com |PC news with out the jargon!
http://sqlthis.blogspot.com | Tsql and More...