[CR #569586] When you run the SQL Server 2005 service patch, the Replication Agent system tables sys.sp_SybSetLogforLOBCol and sys.sp_SybSetLogforReplTable are deleted from the resource database, triggering error 29537:
MSP Error: 29537 SQL Server Setup has encountered the following problem: [Microsoft][SQL Native Client] [SQL Server]Could not find stored procedure 'sys.sp_SybSetLogforLOBCol'.. To continue, correct the problem, and then run SQL Server Setup again.
Workaround: Before you apply the service patch, disable the database triggers that Replication Agent created:
Log in to the primary database.
Disable the automark trigger if it is enabled. For example:
DISABLE TRIGGER ra_createtable_trig_ ON DATABASE
where ra_createtable_trig_ is the automark trigger created by Replication Agent.
Disable the data definition language (DDL) trigger. For example:
DISABLE TRIGGER ra_ddl_trig_ ON DATABASE
where ra_ddl_trig_ is the DDL trigger created by Replication Agent.