Post reply

object name to view schema changes

  • December 2, 2009 at 8:14 am

    #218182

    What is the object name to see what schema changes were made?

    Simply looking for a select statment to see if/when a stored procedure was modified.

    Thanks in advance.

  • December 2, 2009 at 8:40 am

    #1086562

    Found it:

    select * from sys.objects

    where modify_date >= '12/1/09'

    order by name

  • December 2, 2009 at 9:59 am

    #1086653

    Thanks for the update.

    The default trace also might have more information for you if it has not rolled over.

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

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