/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

0 vote240 views1 answer
How to insert multiple values in a single column in sql
SQL
0 vote210 views1 answer
No suitable driver found for sqlite
SQL
0 vote234 views1 answer
How to get nth number in sql
SQL
0 vote216 views2 answers
What is the library that should import to use all functional database features in SQLite?
SQL
0 vote226 views2 answers
Uninstall postgresql mac
SQL
0 vote221 views2 answers
How to set global time_zone in mysql
SQL
0 vote225 views1 answer
Oracle locked objects
SQL
0 vote231 views1 answer
Faire une recherche par liste de mot clé sql
SQL
0 vote244 views2 answers
Postgresql variable in query
SQL
1 vote218 views1 answer
Select count distinct multiple columns sql server
SQL