Nathan Stanford Sr
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.
and another for Triggers?
and for Databases?
Thanks for you help...
I know this is simple for you dba's.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
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
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