Marked table triggers

If a trigger exists on a primary table when that table is marked for replication, the existing trigger is modified to support Sybase replication.

The Sybase replication action in a trigger begins and ends with comments that serve as markers, so that when the table is unmarked, the Sybase replication action can be removed from the trigger.

NoteDo not remove or alter the Sybase replication comments in triggers.

Microsoft SQL Server 7.0 and Microsoft SQL Server 2000 allow multiple triggers of each type to be created on a table. If more than one trigger of a given type exists on a table that you mark for replication, the first trigger is the one modified for Sybase replication.