/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

2 votes348 views1 answer
When matched in sql server
SQL
5 votes325 views1 answer
Sql first day of current year
SQL
0 vote359 views1 answer
When mysql server would not work in xampp
SQL
0 vote361 views1 answer
Oracle running queries
SQL
1 vote359 views1 answer
Where database run
SQL
4 votes342 views3 answers
Mysql modify foreign key
SQL
0 vote363 views1 answer
Psql show db
SQL
6 votes350 views1 answer
T-sql test if table exists
SQL
0 vote344 views1 answer
Mysql dump everythign
SQL
11 votes405 views1 answer
Oracle insert from select
SQL