United States (English)

Home Library Learn Samples Downloads Support Community Forums

MSDN Library

Servers and Enterprise Development

SQL Server

SQL Server 2005

Product Documentation

SQL Server 2005 Documentation

SQL Server 2005 Books Online

SQL Server Language Reference

Transact-SQL Reference

System Views (Transact-SQL)

Dynamic Management Views and Functions

Transaction Related Dynamic Management Views and Functions

sys.dm_tran_active_snapshot_database_transactions

sys.dm_tran_active_transactions

sys.dm_tran_current_snapshot

sys.dm_tran_current_transaction

sys.dm_tran_database_transactions

sys.dm_tran_locks

sys.dm_tran_session_transactions

sys.dm_tran_top_version_generators

sys.dm_tran_transactions_snapshot

sys.dm_tran_version_store

Minimize

2 out of 2 rated this helpful - Rate this topic

Transaction Related Dynamic Management Views and Functions

SQL Server 2005

This section contains the following dynamic management objects.

sys.dm_tran_active_snapshot_database_transactions	sys.dm_tran_active_transactions
sys.dm_tran_current_snapshot	sys.dm_tran_current_transaction
sys.dm_tran_database_transactions	sys.dm_tran_locks
sys.dm_tran_session_transactions	sys.dm_tran_top_version_generators
sys.dm_tran_transactions_snapshot	sys.dm_tran_version_store

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

© 2013 Microsoft. All rights reserved.