0004614: SQL Server trigger creation should use CREATE OR ALTER TRIGGER syntax to eliminate the loss of data capture - SymmetricDS

Summary	0004614: SQL Server trigger creation should use CREATE OR ALTER TRIGGER syntax to eliminate the loss of data capture

Revision	2020-10-30 17:28 by pmarzullo
Description	When SQL Server rebuilds triggers, it first must drop the existing trigger, then create the new trigger, causing the loss of captured data changes if the data on the table changes after the trigger has been dropped but before the new trigger has been created. We should use CREATE OR ALTER TRIGGER to eliminate that chance of lost data capture. This only applies to SQL Server 2016 and later.

Revision	2020-10-30 17:26 by pmarzullo
Description	When SQL Server rebuilds triggers, it first must drop the existing trigger, then create the new trigger, causing the loss of captured data changes if the data on the table changes after the trigger has been dropped but before the new trigger has been created. We should use CREATE OR ALTER TRIGGER to eliminate that chance of lost data capture.