/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 vote190 views1 answer
Pl sql ptint
SQL
0 vote201 views1 answer
"inspanel" intitle:"login" -"cannot" "Login ID" -site:luckyfish.io
SQL
0 vote186 views1 answer
Alter column to not null with default value sql server
SQL
7 votes205 views6 answers
Mysql group concat
SQL
-1 vote196 views1 answer
Pl/sql how to delete a trigger
SQL
0 vote176 views1 answer
Oracle allow space to user
SQL
6 votes175 views1 answer
How to count number of rows in sql
SQL
0 vote160 views1 answer
'0000-00-00' for column '
SQL
0 vote179 views2 answers
Update information in a mysql column
SQL
0 vote218 views1 answer
How to define a non primary composite key in sql
SQL