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.