I have a request from a client to clean up and remove unused databases from their servers.
Is there a quick (easy) way to know when a database was last used by an actual user if the User Detail tracking was not turned on?
I thought about writing a postopen agent in each database and log them in a tracking database, but they don’t want to wait long enough to effectively track all the databases.
I figured a month of tracking would be good but they want to do it this week and any database not used in the past 2 weeks are to be deleted (expect mail files).
Anyone have any good ideas?