Procedure update time

hi
How can I Identify when the procedure was updated last time.
Farhan Iqbal
Farhan wrote:
> hi
> How can I Identify when the procedure was updated last time.
> Farhan Iqbal
There is nothing you can do except look at the log files with a log
reader. SQL Server 7/2000 does not track an "update" date. If the
procedure was dropped and re-created, rather than altered, you can check
the crdate column in sysobjects.
David Gugick
Quest Software
www.imceda.com
www.quest.com
|||Farhan,
There is one way to track the last updated date of stored procedure in SQL
Server to recreate the stored procedure instead of alter.....
Thanks
NOOR
"Farhan" <Farhan@.discussions.microsoft.com> wrote in message
news:3AA6753A-E7D5-42F8-B477-26DD1719A094@.microsoft.com...
> hi
> How can I Identify when the procedure was updated last time.
> Farhan Iqbal