sp_stored_procedures help

[John Wright]

I need to list all the stored procs in my database. I use the
sp_stored_prodecures SP which returns all the stored procs in the database
including the system stored procedures. If is use the qualifier
sp_stored_procedures, null, 'DBO' I can filter out the sys owners but I
still get about 7 sp_ stored procedues like sp_alterdiagram,
sp_creatediagram, 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]

I need to list all the stored procs in my database. I use the
sp_stored_prodecures SP which returns all the stored procs in the database
including the system stored procedures. If is use the qualifier
sp_stored_procedures, null, 'DBO' I can filter out the sys owners but I
still get about 7 sp_ stored procedues like sp_alterdiagram,
sp_creatediagram, 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'