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

Arthur Fuller artful at rogers.com
Sun Feb 26 09:42:03 CST 2006


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




More information about the dba-SQLServer mailing list