/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 vote117 views9 answers
Linq to sql converter online
SQL
0 vote131 views1 answer
Sql server current time without date
SQL
5 votes128 views1 answer
Oracle nls parameters
SQL
0 vote378 views1 answer
Create pl/sql stored procedure
SQL
0 vote121 views1 answer
Mysqlimport
SQL
10 votes116 views2 answers
Oracle alter sequence nextval
SQL
0 vote112 views2 answers
How to delete the rows with null values in mysql
SQL
-1 vote151 views1 answer
Mysql faster insert
SQL
1 vote134 views1 answer
Python clean sql string
SQL
10 votes107 views3 answers
Sql limit results
SQL