/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 vote189 views1 answer
Mysql start of today
SQL
0 vote187 views1 answer
Oracle synonym procedure
SQL
1 vote217 views1 answer
Oracle show execution plan
SQL
0 vote230 views1 answer
Get null value in sql
SQL
0 vote247 views1 answer
Sql cheetsheet
SQL
8 votes196 views3 answers
Connect python to mysql
SQL
0 vote239 views1 answer
Pl sql search in all packages
SQL
3 votes198 views2 answers
Plsql print
SQL
1 vote225 views3 answers
Sql procedure
SQL
0 vote183 views1 answer
View t-sql mail configuration
SQL