This is a view in the mssqlsystemresource database. Returns information about transactions at the database level, especially transaction log information such as the log sequence number (LSN), log bytes used, and transaction type.
Syntax
CREATE VIEW sys.dm_tran_database_transactions AS
SELECT *
FROM OpenRowset(TABLE DATABASE_TRANSACTIONS)