Is there any way to identy that procedure last modified date?

• indraprakash

  SSChasing Mays

  Points: 637

  More actions

  October 3, 2008 at 6:55 am

  #126627

  Hi All,

  Is there any way to identy that procedure last modified date in SQL Server 2000?

  Thanks

• Madhivanan-208264

  SSCertifiable

  Points: 7516

  More actions

  October 3, 2008 at 7:07 am

  #880438

  indraprakash (10/3/2008)

  ---

  Hi All,

  Is there any way to identy that procedure last modified date in SQL Server 2000?

  Thanks

  No until you document it

  ---

  Madhivanan

  Failing to plan is Planning to fail

• homebrew01

  SSC Guru

  Points: 55548

  More actions

  October 3, 2008 at 8:08 am

  #880484

  Or buy (or create) a tool such as Idera Compliance Manager to monitor SQL activity.

  Ideally, you would put a comment in the SP noting the revision #, date, description & person making the change.