✏️ Explanatory Question

What does Created Transaction ID = Yes mean?

👁 2 Views
📘 Detailed Answer
⚪ N/A
← Previous Where is the Created Transaction ID property found?
💡

Answer with Explanation

When set to Yes:

  • The system stores the transaction ID at record creation

  • Used for transaction tracking

  • Helpful in financial and critical business tables

  • Enables better rollback and consistency control

Typical use cases:

  • Ledger tables

  • Inventory transactions

  • Settlement tables

  • Audit-sensitive data

 What does Created Transaction ID = No mean?

Answer:
When set to No:

  • No transaction ID is stored

  • Slightly better performance

  • Less database overhead

  • Suitable for reference, setup, or temporary data

Typical use cases:

  • Parameter tables

  • Setup tables

  • Staging tables

  • TempDB tables

← Previous Where is the Created Transaction ID property found?