/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 vote197 views2 answers
SQLSTATE[42000]: Syntax error or access violation: 1075 Incorrect table definition; there can be only one auto column and it must be defined as a key"
SQL
1 vote263 views1 answer
Pentaho + pasar de excel a sql
SQL
1 vote205 views1 answer
Postgres first_value in gropby
SQL
0 vote207 views3 answers
How to increase size of column in sql
SQL
0 vote209 views1 answer
Count columns psql(PostreSQL)
SQL
1 vote220 views1 answer
How to convert number to hours and minutes in oracle sql
SQL
11 votes209 views1 answer
Creating tables in sql with python
SQL
15 votes211 views2 answers
Sql order by multiple columns
SQL
0 vote204 views1 answer
Sql server query database space available
SQL
0 vote196 views1 answer
Android sqlite get rows count
SQL