Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 stored procedure

Author  Topic 

sqldba2k6
Posting Yak Master

176 Posts

Posted - 2006-08-10 : 13:40:40
stored procedure Created date can be tracked in the enterprise Manager but how to identify or check the last time(Date) stored procedure was altered.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-08-10 : 13:48:50
That's not possible in SQL Server versions older than 2005. This is why some people only use drop/create when they need to modify a stored procedure. We use source control, so we are fine with alters as source control will tell us the last update.

Tara Kizer
Go to Top of Page
   

- Advertisement -