Replication Agent for Microsoft SQL Server must create database objects (tables, triggers, and procedures) in the primary database for its transaction log.
The user ID that the Replication Agent instance uses to log in to the Microsoft SQL Server must have access to the primary database with the following permissions granted:
Create table
Create trigger
Create procedure
Create trigger permission cannot be transferred from
the table owner in Microsoft SQL Server 6.5. If you use Microsoft
SQL Server 6.5 with Replication Agent for Microsoft SQL Server, you may
have to create transaction log triggers by manually running the
trigger-creation scripts using the table owner’s user ID
for each replicated table.
