sp_stored_procedures help

[John Wright]

I need to list all the stored procs in my database. I use the
sp_stored_prode cures SP which returns all the stored procs in the database
including the system stored procedures. If is use the qualifier
sp_stored_proce dures, null, 'DBO' I can filter out the sys owners but I
still get about 7 sp_ stored procedues like sp_alterdiagram ,
sp_creatediagra m, etc. When I look in Management Studio these are listed as
system procs. What qualifier do I need to only list non system stored
procedures?

Thanks.

John

[Harry]

Re: sp_stored_proce dures help

"John Wright" <riley_wright@h otmail.comwrote in message
news:u$HDMtouIH A.1772@TK2MSFTN GP03.phx.gbl...

>I need to list all the stored procs in my database. I use the
>sp_stored_prod ecures SP which returns all the stored procs in the database
>including the system stored procedures. If is use the qualifier
>sp_stored_proc edures, null, 'DBO' I can filter out the sys owners but I
>still get about 7 sp_ stored procedues like sp_alterdiagram ,
>sp_creatediagr am, etc. When I look in Management Studio these are listed
>as system procs. What qualifier do I need to only list non system stored
>procedures?
>
Thanks.
>
John
>

USE [MyDB]

SELECT name

FROM sysobjects

where xtype = 'p'