select
name from master.dbo.sysobjects where type = 'P'

--- anthony.[Email Address Removed] wrote:
> I know this is a simple one, but the answer evades
> me for the moment..
>
> How do i return a list of all stored procs in the
> master DB
>
> Thanks..
>
>
> AJ
>
>
>
>
>
>
**********************************************************************
> "The information contained in this email and any
> attached files is strictly private and confidential.
> This email should be read by the intended addressee
> only. If the recipient of this message is not the
> intended addressee, please call Aon Risk Services
> Australia, Aon Consulting, Aon Re Australia Ltd and
> other associated Aon Companies on +61 2 92537000 and
> promptly delete this email and any attachments.
>
> The intended recipient of this email may only use,
> reproduce, disclose or distribute the information
> contained in this email and any attached files with
> Aon's permission. If you are not the intended
> addressee, you are strictly prohibited from using,
> reproducing, disclosing or distributing the
> information contained in this email and any attached
> files.
>
> Aon advises that this email and any attached files
> should be scanned to detect viruses. Aon accepts no
> liability for loss or damage (whether caused by
> negligence or not) resulting from the use of any
> attached files."
>
**********************************************************************
>
>
>
---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT
> JUST REPLY
> To unsubscribe, e-mail:
> mssqldba-[Email Address Removed] For additional commands, e-mail:
> mssqldba-[Email Address Removed]

MS Sql Server LazyDBA home page