/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 vote301 views1 answer
Sql alter column name sql server
SQL
0 vote302 views1 answer
A good way of running a SQL query in JDBC using a parameterized statement
SQL
0 vote291 views1 answer
Pgsql is not permitted to log in
SQL
1 vote297 views1 answer
How to show index type in postgresql
SQL
0 vote287 views1 answer
Sql getdate minus 1 day without time
SQL
1 vote267 views1 answer
Sql update table remove spaces
SQL
0 vote298 views1 answer
Insert or update sql firebird
SQL
0 vote273 views1 answer
Ffeathers express mysql application users login
SQL
0 vote288 views1 answer
Oracle service name view
SQL
1 vote277 views1 answer
Mysql pretty date format
SQL