Link to home
Start Free TrialLog in
Avatar of Nathan Stanford Sr
Nathan Stanford SrFlag for United States of America

asked on

How can I create a Stored Procedure to list all Stored Procedures?

How can I create a Stored Procedure to list all Stored Procedures in Date Order?

and another for Triggers?

and for Databases?


Thanks for you help...

I know this is simple for you dba's.
Avatar of acampoma
acampoma



select * from sysobjects where xtype='P' order by crdate
select * from sysobjects where xtype='TR' order by crdate
select * from master..sysdatabases order by crdate
ASKER CERTIFIED SOLUTION
Avatar of acampoma
acampoma

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Nathan Stanford Sr

ASKER

Thanks... Is there a way to not show System SP's only User ones?
where status=0 or category=0
I'm not sure what these fields mean. I just noticed that they are both set to 0 for all my user stored procs.
good luck