Procedure Objects

Replication Agent creates procedure objects in the Microsoft SQL Server primary database.

The table below lists the procedure objects that are considered Replication Agent objects. The sp_SybSetLogforReplTable, sp_SybSetLogforReplProc, and sp_SybSetLogforLOBCol procedures are created in the Microsoft SQL Server mssqlsystemresource system database. Although execute permission on these procedures is granted to Public, only the Replication Agent pds_username user can successfully execute the procedures because only the pds_username user is granted select permission on the sys.sysschobjs table. No permissions are granted on the other procedures when they are created.

Note: The stored procedures listed here have no effect when executed outside the context of replication.
Replication Agent Procedure Objects

Object

Name

Marks/unmarks an object

prefixmark_xxx

Verifies an object

prefixcheck_xxx

Retrieves the ID of the last committed transaction

prefixlct_sql_xxx

Marks/unmarks a table

sp_SybSetLogforReplTable

Marks/unmarks a procedure

sp_SybSetLogforReplProc

Marks/unmarks LOB column

sp_SybSetLogforLOBCol