/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 vote346 views1 answer
Backup and restore of sqlite database from c# -sqlserver
SQL
0 vote384 views1 answer
R dbConnect(odbc::odbc() to ms sql server remote
SQL
2 votes369 views1 answer
Query any digits record
SQL
2 votes368 views1 answer
Sql finding longest and shortest names in a fleld
SQL
3 votes323 views1 answer
Mysql CURRENT_TIMESTAMP()
SQL
1 vote354 views1 answer
Mysql limit results to 10
SQL
1 vote370 views1 answer
Vagrant mysql downgrade version
SQL
0 vote405 views1 answer
Implode in sql query
SQL
0 vote380 views1 answer
How to import pymysql through jupyter notebook for windows
SQL
0 vote348 views1 answer
SQL SERVER SELECT BETWEEN DATETIME
SQL