Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| transaction_id | uniqueidentifier | 16 | null |
|
|
|||
| database_id | int | 4 | null |
|
|
|||
| iso_level | int | 4 | null |
|
|
|||
| can_commit | int | 4 | null |
|
|
|||
| enlistment_state | int | 4 | null |
|
|
|||
| resource_manager_id | uniqueidentifier | 16 | null |
|
|
|||
| server_name | nvarchar | 522 | √ | null |
|
|
||
| database_name | nvarchar | 258 | √ | null |
|
|
||
| transaction_manager_server_name | nvarchar | 522 | √ | null |
|
|
||
| transaction_manager_database_name | nvarchar | 258 | √ | null |
|
|
||
| transaction_manager_database_id | int | 4 | null |
|
|
|||
| transaction_manager_rmid | uniqueidentifier | 16 | null |
|
|
|||
| prepare_lsn | nvarchar | 48 | √ | null |
|
|
||
| snapshot_timestamp | bigint | 8 | null |
|
|
|||
| oldest_active_lsn | nvarchar | 48 | √ | null |
|
|
||
| prepare_elapsed_time | bigint | 8 | null |
|
|
|||
| object_ref_count | int | 4 | null |
|
|
|||
| transaction_timeout | int | 4 | null |
|
|
|||
| diag_status | int | 4 | null |
|
|
Relationships
Close relationships within degrees of separation
