/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

6 votes266 views1 answer
Oracle rank() over (partition)
SQL
-1 vote298 views1 answer
Pl sql drop trigger
SQL
0 vote299 views1 answer
Show mysql account privilleges
SQL
0 vote313 views1 answer
Show all sequences postgres
SQL
10 votes272 views2 answers
Reset mysql root password mac
SQL
14 votes286 views4 answers
Online sql compiler
SQL
16 votes277 views6 answers
Mysql find and replace
SQL
-1 vote243 views1 answer
Plsql while
SQL
3 votes260 views3 answers
Mysqldump: couldn
SQL
13 votes290 views1 answer
Select count of distinct values sql
SQL