Nested stored procedures are not allowed.
00:00000:00011:2006/06/13 16:26:05.12 server Error: 9202, Severity: 20, State: 0 00:00000:00011:2006/06/13 16:26:05.12 server RepAgent(5): Nested replicated stored procedure detected. Transaction log may be corrupt. Please contact SYBASE Technical Support. (current marker = 1372, 12) 00:00000:00011:2006/06/13 16:26:05.12 server Rep Agent Thread for database 'pdb' (dbid = 5) terminated abnormally with error. (major 92, minor 2)
A nested stored procedure is called from within another stored procedure. The stored procedure that calls the nested stored procedure is called the outer stored procedure.
dbcc gettrunc
dbcc traceon(3604) dbcc pglinkage(dbid, pageid, 0,2,0,1)where pageid is the ID for the page you received by executing dbcc gettrunc in step a.
dbcc settrunc (‘ltm’, ‘pageid’, pageid)where pageid is the ID for the page after the current page you retrieved using dbcc pagelinkage in step b.
rs_zeroltm