Add sys.indexes create_date and modify_date fields
My company needs a way to easily identify when an index was created. It would also be useful to know when an index's ddl was last modified.
Upvotes: 28<=-=Jan 15 2009 2:43PM=-=>
Thanks for your request. We are aware of your ask and we will consider it for a future version of SQL Server. For now, you can create DDL trigger and track the index creation/alter in your own tables. This will allow you to get the information you are looking for.
Umachandar, SQL Programmability Team
I’d also like to throw some support around this as something to include in the next version of SQL Server<=-=Dec 3 2009 7:59AM=-=>
I’d like to see thes as well. I’d also add that seeing last rebuild date and last reorg date would be helpful as well, even if they were via function like STATS_DATE().<=-=Dec 3 2009 8:04AM=-=>
Upvoted as I think this is definitely something that needs to be added. In addition to adding this, please add a related report in SSMS to this.<=-=Oct 16 2012 10:53AM=-=>
We’ve been asking for this for years. This isn’t the first time a Connect item has been filed for this.<=-=Nov 12 2014 11:19AM=-=>
Thanks for submitting this request. As there are 28 votes, it is understoond that this is a significant ASK. As you know, a work-around for this is using create a DDL trigger & track history of DDL statements but I agree it is not clean. At this time, in general the create/modify dates are not available in general across different objects. And in fact, in some places modify_date is not really updated. Ideally, we need to make it uniform across all catalog objects and make sure create/modify dates are updated correctly. This is non-trivial amount of work
Will be interested in your feedback if trigger work-around is acceptable?
Also, want to add one more point. Some ot the customers had pointed out they want to be able to track what DDL changes were done. For these scenario, the mpodify_date will not suffice and you will need DDL trigger
Thanks for your reply. Yes, DDL triggers are an option but it would be nice out of the box functionality in SQL Server if create_date and modify_date fields were available on sys.indexes.<=-=Feb 3 2015 11:01AM=-=>
Brian, sorry to disappoint you here but at this time, we will not invest in this change. DDL trigger is our recommendations. I am closing this but I do appreciate your feedback