Track modifed date and time of a stored procedure | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Track modifed date and time of a stored procedure

Is there an automatic method to track when a stored procedure is changed and/or what login is used? wingman
With profiler you can add login name column to find out what user is using sp.
Luis Martin
Moderator Although nature commences with reason and ends in experience it is necessary for us to do the opposite, that is to commence with experience and from this to proceed to investigate the reason.
Leonardo Da Vinci Nunca esperes el reconocimiento de tus hijos, eso ocurrirá luego de tu muerte
All postings are provided “AS IS” with no warranties for accuracy.
Review the article by Ken Henderson to accomplish the task. Satya SKJ
Contributing Editor & Forums Moderator
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.