How to get the dates on which a proc is altered ?

Hi All,
I want to see the dates on which a proc is altered in a database.
Is there any way to get this information ?
Regards
Satyatry this...
select LAST_ALTERED from information_Schema.routines
where routine_name = '<proc_name>'
and routine_type = 'procedure'
hope this helps.
--
-Omnibuzz (The SQL GC)
http://omnibuzz-sql.blogspot.com/|||Hi,
I am using SQL 2000.
LAST_ALTERED is same as CREATED, eventhough I altered the proc.
Regards
Satya
"Omnibuzz" wrote:

> try this...
> select LAST_ALTERED from information_Schema.routines
> where routine_name = '<proc_name>'
> and routine_type = 'procedure'
> hope this helps.
> --
> -Omnibuzz (The SQL GC)
> http://omnibuzz-sql.blogspot.com/
>|||Hi
In SQL Server 2000 you can't, however in SQL Server 2005 it is posible ,
lookup modified_date if I rememver well
"Satya" <Satya@.discussions.microsoft.com> wrote in message
news:A0AB9BE9-29E4-4090-84D2-340B5CD44A8E@.microsoft.com...
> Hi,
> I am using SQL 2000.
> LAST_ALTERED is same as CREATED, eventhough I altered the proc.
> Regards
> Satya
>
> "Omnibuzz" wrote:
>|||Oh.. yeah.. Forgot totally about it.
Its not implemented in SQL 2k.. That column was there because of ANSI
compilance view definition and actually holds the created date info :)
SQL Server 2000 does not store the information and you cannot get it.
It was implemented though, in 2k5.
--
-Omnibuzz (The SQL GC)
http://omnibuzz-sql.blogspot.com/