Thursday, 7 May 2015

sql for database names created in desc order

I got more than 50 dev crm org, and I created one and forgot which one is the latest one, in order to find that I used following sql it lists all the database names order by created date in desc

SELECT * FROM sys.databases ORDER BY create_date  desc

No comments:

Post a Comment