/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

1 vote326 views1 answer
Raw query must include primary key
SQL
0 vote347 views1 answer
Sql convert unix time to date
SQL
0 vote340 views1 answer
Cannot start database server xampp mac os
SQL
5 votes337 views4 answers
Change auto increment mysql
SQL
0 vote362 views1 answer
Mysql error 1114 (hy000) the table is full
SQL
-1 vote396 views1 answer
How to Activate the database
SQL
0 vote309 views1 answer
Npm ERR! code ELIFECYCLE npm ERR! errno 1 npm ERR! [email protected] install: `node-pre-gyp install --fallback-to-build` npm ERR! Exit status 1 npm ERR! npm ERR! Failed at the [email protected] install script.
SQL
8 votes320 views1 answer
Oracle add month
SQL
0 vote304 views7 answers
10 random questions use python and SQL
SQL
0 vote359 views1 answer
Command to give readonly access to a postgres sql user
SQL