/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 vote213 views2 answers
Denormalization in sql
SQL
0 vote285 views3 answers
Drop table operation failed on table 'TableHistory' because it is not supported operation on system-versioned temporal tables.
SQL
0 vote273 views1 answer
Error: com.mysql.cj.jdbc.Driver not loaded. Are you sure you've included the correct jdbc driver in :jdbc_driver_library?
SQL
0 vote263 views1 answer
Start and stop mysql
SQL
3 votes294 views4 answers
Truncate syntax in sql
SQL
18 votes282 views3 answers
Get the list of all tables in sql server
SQL
1 vote250 views1 answer
Postgres format date in select
SQL
11 votes282 views3 answers
How to get last row of table in sql
SQL
15 votes365 views5 answers
Select all tables sql
SQL
1 vote273 views1 answer
How to start with sql
SQL