Q. In my inhouse Birdview instance, I'm getting the following error when saving a project or an activity. I'm using SQL Server Express.
The transaction has aborted
A. The important thing which helps to reduce lock contention in addition to upgrading to full SQL server version is the following script. It should be run on your SQL server where the Birdview database is located. Before running the script, the SQL server service should be restarted.
Note that the text "MyDatabase" (two occurrences) should be replaced with a real database name of Birdview.
ALTER DATABASE MyDatabase
SET ALLOW_SNAPSHOT_ISOLATION ON
ALTER DATABASE MyDatabase
SET READ_COMMITTED_SNAPSHOT ON