Post reply

Script to track when Stored Procedures were changed

  • September 30, 2015 at 10:52 am

    #399118

    Does anyone have a script to identify when Stored Procedures were changed?

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • September 30, 2015 at 10:57 am

    #1830513

    SELECT * FROM sys.procedures

    It's not going to tell you what was changed, or by who, just when the procedure was created and modified. The what and the who you get from your source control system.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • September 30, 2015 at 11:53 am

    #1830536

    Of course, this only works if you use CREATE PROCEDURE ... to create new procedures and ALTER PROCEDURE ... to modify existing stored procedures. I know of companies the use DROP PROCEDURE ... CREATE PROCEDURE whn updating procedures.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply