This is a view in the mssqlsystemresource database. Returns information about transactions (such as the state of the transaction, when it began, whether it is read-only or not, and so forth) executing within the SQL Server instance.
Syntax
CREATE VIEW sys.dm_tran_active_transactions AS
SELECT *
FROM OpenRowset(TABLE ACTIVE_TRANSACTIONS)