/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

3 votes293 views6 answers
Sql unique select
SQL
10 votes152 views2 answers
Sql rtrim
SQL
0 vote150 views1 answer
Mysql config address
SQL
0 vote203 views1 answer
SQL Server Altering Column to be Unique
SQL
0 vote163 views1 answer
Oracle concat datetime
SQL
0 vote171 views1 answer
Get only structure database mysql
SQL
0 vote179 views2 answers
Get value from a table an insert it with other values in another table sql
SQL
16 votes155 views3 answers
T-SQL Add Column
SQL
0 vote176 views1 answer
Add new column in sql with foreign key
SQL
0 vote152 views2 answers
T SQl Checking Your Username
SQL