View Revisions: Issue #3576
| Summary | 0003576: Sync triggers fails with deadlock on SQL-Server | ||
|---|---|---|---|
| Revision | 2018-05-23 16:12 by kstojanovska | ||
| Description | Resync trigger if it is failing due to deadlock | ||
| Revision | 2023-01-31 18:43 by elong | ||
| Description | On SQL-Server, if the mssql.trigger.order.first parameter is used, it will query system tables to see if there is any existing trigger ordered as first. The query can get a deadlock with other queries on the same system table because of the isolation used on the query. | ||