Post reply

How to find stored procedures that have been modified

  • December 20, 2007 at 9:09 am

    #76850

    Does anyone know of a way to find all the stored procedures, views, etc. in a database that have been modified since a certain date?

    Thanks!

  • December 20, 2007 at 7:52 pm

    #761969

    You can right click on a database in the 2005 management studio, go to reports, standard reports, then choose the Schema Changes History report. However, I'd love to know what this is tapping underneath the surface so we could do our own custom queries on this data...

  • December 24, 2007 at 7:00 am

    #762530

    Thank you, that is what I was looking for, however, it seems to be picking a random date to show the changes since (12/12/07). Any idea where it gets this date?

    Thanks!

  • December 27, 2007 at 12:30 am

    #762856

    SELECT name from sys.procedures where modify_date > @MyDate

    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

  • December 27, 2007 at 7:03 am

    #762918

    That is exactly what I needed, thank you!

  • January 3, 2008 at 12:43 am

    #764277

    select * from sys.objects

    where type='P' and modify_date>getdate()-2

    order by modify_date desc

Viewing 6 posts - 1 through 5 (of 5 total)

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