SQLServer: when was the DB last used
SELECT UNPVT.[DataBase], MaxLastUse = MAX (UNPVT.MaxLastUse) INTO #tempdatabases FROM ( SELECT [DataBase], last_user_seek, last_user_scan, last_user_lookup, last_user_update FROM ( SELECT [DataBase] = DB.[name], last_user_seek = MAX (IU.last_user_seek), last_user_scan = MAX (IU.last_user_scan), last_user_lookup = MAX (IU.last_user_lookup), last_user_update = MAX (IU.last_user_update) FROM sys.databases AS DB INNER JOIN sys.dm_db_index_usage_stats AS IU ON IU.database_id = DB.database_id GROUP BY DB.[name] ) AS DBIU ) AS P UNPIVOT(MaxLastUse FOR ColumnName IN (last_user_seek, last_user_scan, last_user_lookup, last_user_update)) AS UN...