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.

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