Reserved names  Getting actual names of the transaction log objects

Chapter 3: Replication Agent for Microsoft SQL Server

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.





Copyright © 2005. Sybase Inc. All rights reserved. Getting actual names of the transaction log objects

View this book as PDF