sp_stored_procedures help

  • Thread starter Thread starter John Wright
  • Start date Start date
J

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
 
John Wright said:
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
Click to expand...
USE [MyDB]

SELECT name

FROM sysobjects

where xtype = 'p'
 
Back
Top