object name to view schema changes

  • 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.

  • Found it:

    select * from sys.objects

    where modify_date >= '12/1/09'

    order by name

  • 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