Question: I have created indexes on my DB the last 2 months. Everything works fine. However, now I have to move those indexes to the UAT ENV. I kept track of the indexes I created. However I want to be sure I didn't miss any. How do I know the indexes created in the last 2 months using a query?

Answer: 
SQL Server does not maintain index creation information for indexes in a DMV. This is not information you can query.

You can get this information for PK, unique indexes or unique constraints.

See Kendra Little's blog [here](https://www.littlekendra.com/2016/12/13/index-create-and-last-modified-dates-in-sql-server/) for some good info on this topic.

From Kendra's post:

> 
> But if you’re not looking for the create date of a Primary Key, unique index, or unique constraint, you’re out of luck.
> 
> 
>
Thanks for all the responses. There is really no good way to find the indexes created in last two months. The best way is to load the indexes in a table and compare them with DEV Indexes.