Q. 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 is the following script.
Please run it on your SQL server where EP 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 EP.