/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

24 votes218 views5 answers
List mysql users
SQL
0 vote198 views1 answer
Sql get user account
SQL
0 vote201 views1 answer
Count the table indatabase
SQL
4 votes192 views1 answer
Mac install mysql
SQL
5 votes199 views1 answer
Ascending order and where in sql
SQL
0 vote204 views1 answer
Postgres enumerated type
SQL
7 votes192 views1 answer
Sql management studio display line numbers
SQL
12 votes216 views5 answers
Rename table in mysql
SQL
4 votes193 views1 answer
Oracle error compilation line
SQL
14 votes216 views4 answers
Remove record from table sql
SQL