View Revisions: Issue #4614

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.