Add create_date and modify_date to sys.indexes
The system view for indexes (sys.indexes) does not have a create or modify date. This makes it difficult to track when a new index was created or changed.
Upvotes: 2<=-=Mar 21 2017 1:12PM=-=>
Thank you for your feedback!
We will consider this improvement for the future releases of SQL Server and Azure SQL Database.
Gé Brander commented
This request is already for more than 10 years in one way or the other known to Microsoft. Is this ever going to be added? I visit many different customers and the DDL trigger option is nice but this is never implemented at customers where I need to be able to see this information. So it would be of great value to have this in the products available. Please reconsider to implement this.