how to order stored procedures or tables by date

Question

We used to do this extensively in the old enterprise manager.. this is needed on big systems with lots of tables and stored procedures becuase you normally don't remember the name but it is the most recent thing you were working on..

 

anyone know how to do this in the new sql server management studio..

thanks

Answer 1

There is create date in sysobjects but there is no last updated date.
So if you use alter procedure there is no trace.
But if you use drop procedure + create procedure, then you can use crdate.

use adventureworks
select name, crdate, refdate
from sysobjects
where type = 'P' (or 'U')
order by crdate

Vincent

Answer 2

In 2005 I would use system catalog view.
Vincent