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

Robert L. Stewart rl_stewart at highstream.net
Mon Feb 27 09:16:05 CST 2006


Arthur,

No UDFs, so I cannot answer that for you.

SQL 2005:

SELECT * FROM sys.all_objects WHERE [type] = 'p'

SQL 2000:

SELECT * FROM sysobjects WHERE xtype = 'p'

This will give you all of the information for the stored procs so you can use
that list to walk through.  I am not sure where the souce code for them resides
yet.


Robert L. Stewart
The Dyson Group International
Software for the Non-profit Enterprise
Expanding your Sphere of Knowledge

> Date: Sun, 26 Feb 2006 10:42:03 -0500
> From: "Arthur Fuller" <artful at rogers.com>
> Subject: [dba-SQLServer] Walk the lists of sprocs and udfs
> To: <dba-sqlserver at databaseadvisors.com>
> Message-ID: <013d01c63aeb$31430840$8e01a8c0 at rock>
> Content-Type: text/plain;	charset="us-ascii"
>
> 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