views:

143

answers:

2

Anyone know a simple query to grab a list of all stored procedures in a SQL 2005 database ordered by createdate?

+6  A: 

one way

select name from sys.procedures
where type = 'P'
order by create_date
SQLMenace
Yup, but as you specify sys.procedures (as opposed to sys.objects) you don't need to write the condition type='P', do you? Cheers
antonioh
+4  A: 

select * from sys.objects where [type] = 'P' order by create_date

Dan Appleyard