如何查找SQL Server数据库数据库用户最近使用的数据库。...给您whodunnit信息,您可以分组以获取最小/最大事件时间
```js
WITH myCTE AS
(
SELECT
DB_NAME(database_id) AS TheDatabase,
last_user_seek,
last_user_scan,
last_user_lookup,
last_user_update
FROM
sys.dm_db_index_usage_stats
)
SELECT
ServerRestartedDate = (SELECT CREATE_DATE FROM sys.databases where name='tempdb'),
x.TheDatabase,
MAX(x.last_read) AS last_read,
MAX(x.last_write) AS last_write
FROM
(SELECT
TheDatabase, last_user_seek AS last_read, NULL AS last_write
FROM
myCTE
UNION ALL
SELECT
TheDatabase, last_user_scan, NULL
FROM
myCTE
UNION ALL
SELECT
TheDatabase, last_user_lookup, NULL
FROM
myCTE
UNION ALL
SELECT
TheDatabase, NULL, last_user_update
FROM
myCTE) AS x
GROUP BY
TheDatabase
版权声明:本文内容由阿里云实名注册用户自发贡献,版权归原作者所有,阿里云开发者社区不拥有其著作权,亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容,填写侵权投诉表单进行举报,一经查实,本社区将立刻删除涉嫌侵权内容。