SQL Server Performance Forum – Threads Archive

sp’s

is there a way to find the modified date for a store procedure?

---

Not if you use ‘Alter procedure’ for modifying it. And that’s why it’s a good practice to leave your comments with date when you modify it.
But I know of some developers from SQL 6.5 generation, who still use the drop and create procedure technique for modifying SPs. If it is the case, then the create date is the modified date.

---

SQL Server doesn’t handle such data or date changes for the SPs, rather you can deploy auditing the the database by using third party tools or controlling the code using VIsual Source Safe or PVCS. HTH _________
Satya SKJ
Moderator
SQL-Server-Performance.Com

---

]]>