/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 vote222 views1 answer
Show all mongodb
SQL
3 votes175 views1 answer
Mysql set field unique
SQL
0 vote172 views1 answer
Postgres data location
SQL
41 votes259 views6 answers
Alter table add column in SQL Server
SQL
0 vote172 views1 answer
Python sql last insertend
SQL
3 votes219 views1 answer
Sql select second max
SQL
16 votes192 views2 answers
Sql vs nosql
SQL
3 votes219 views2 answers
Funktion LOWER/UPPER sql
SQL
0 vote180 views1 answer
Mysql set boolean default value
SQL
2 votes214 views1 answer
Datefromparts mssql
SQL