Diana:

BOL spune ca sys.objects.modufy_date este "Date the object was last modified by using an ALTER statement. If the object is a table or a view, modify_date also changes when a clustered index on the table or view is created or altered."...