/SQL/Sql last time database was accessed

Sql last time database was accessed

SELECT d.name,
last_user_seek = MAX(last_user_seek),
last_user_scan = MAX(last_user_scan),
last_user_lookup = MAX(last_user_lookup),
last_user_update = MAX(last_user_update)
FROM sys.dm_db_index_usage_stats AS i
JOIN sys.databases AS d ON i.database_id=d.database_id
GROUP BY d.name

Source: stackoverflow.com

Similar codes

1 vote337 views1 answer
Find size of all DB's postgres
SQL
2 votes323 views1 answer
Oracle block
SQL
0 vote277 views1 answer
Default column value in sql same as other column
SQL
8 votes303 views5 answers
Grant permission in postgres
SQL
-1 vote330 views2 answers
Mysql get day of week
SQL
5 votes295 views1 answer
Oracle ora-00054 resource busy
SQL
3 votes280 views1 answer
Search for column name in psql
SQL
11 votes322 views2 answers
Oracle saurce code
SQL
0 vote317 views1 answer
Sql log file inof
SQL
0 vote294 views1 answer
Contact mysql column field
SQL