NEW4.01.02 · Released 12 September 2024
NEWfinPOWER Connect
Released in
4.01.02
12 September 2024
  1. Opened31 Jul
  2. Closed1 Aug
  3. Released12 Sep
Article 21739 Job J034011

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

On the Help, Support, Support Information Report, additional information has been added for MS SQL Azure 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'.
  • Read Committed Snapshot Isolation
    • This indicates whether the Read Committed Snapshot Isolation (RCSI) is enabled for the database.
    • Only included enabled.
  • Snapshot Isolation State
    • This describes the state of the Snapshot Isolation feature in the database.
    • Note, the MS Azure database default is ON, i.e. the default is Read Committed Snapshot Isolation (RCSI).
    • Only included if enabled.
  • Database Table Information
    • Statistics about number of rows, sizes etc