TransactionTypes Enum
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Specifies the types of transactions that may be active in a database
This enumeration supports a bitwise combination of its member values.
C#
[System.Flags]
public enum TransactionTypes[<System.Flags>]
type TransactionTypes = Public Enum TransactionTypes- Inheritance
-
TransactionTypes
- Attributes
| Name | Value | Description |
|---|---|---|
| Versioned | 1 | A Versioned transaction has a row in sys.dm_tran_active_snapshot_database_transactions |
| UnVersioned | 2 | An UnVersioned transaction does not have a row in sys.dm_tran_active_snapshot_database_transactions |
| Both | 3 | Specifies inclusion of both Versioned and UnVersioned transactions |
| Product | Versions |
|---|---|
| Microsoft.SqlServer.SqlManagementObjects | 150.18208.0, 160.2004021.0 |