Table 2-5 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 is able to 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.
The stored procedures listed in Table 2-5 have no effect
when executed outside the context of replication.
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 |
