Tuesday, January 31, 2006 6:53 PM
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..
Wednesday, February 01, 2006 1:08 AM
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.
select name, crdate, refdate
where type = 'P' (or 'U')
order by crdate
Thursday, February 02, 2006 7:24 AMIn 2005 I would use system catalog view.