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
2009-04-27 16:11:58
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
2009-04-27 16:22:57
+4
A:
select * from sys.objects where [type] = 'P' order by create_date
Dan Appleyard
2009-04-27 16:14:42