Article Details
Id:21736
Product:finPOWER Connect
Type:NEW
Version:4.01.02
Opened:26/06/2024
Closed:31/07/2024
Released:12/09/2024
Job: J033798

Help, Support Information; added extra Database schema information for MS SQL Server

On the Help, Support, Support Information Report, additional information has been added for MS SQL Server databases.

This includes:

  • Isolation Level
    • Either "Unspecified", "Read Uncommitted", "Read Committed", "Repeatable Read", "Serializable" or "Snapshot".
    • Note, for finPOWER Connect this should always be "Read Committed".
    • A warning is shown if the Database Isolation Level is not 'Read Committed'.
  • ReadCommittedSnapshotIsolation
    • This indicates whether the Read Committed Snapshot Isolation (RCSI) is enabled for the database.
    • Only included enabled.
  • SnapshotIsolationState
    • This describes the state of the Snapshot Isolation feature in the database.
    • Only included if enabled.