A stored procedure in the replicate database that users can customize to manipulate rs_ticket_param.
rs_ticket_report rs_ticket_param
Contains timestamp and byte information for EXEC, DIST, and DSI transactions.
Customized rs_ticket_report stored procedure:
create procedure rs_ticket_report
@rs_ticket_param varchar(255)
as
begin
set nocount on
declare @new_cmd varchar(255),
@c_time datetime,
@c_secs numeric(6,3)
select @c_time = getdate()
select @c_secs = datepart( millisecond, @c_time)
select @c_secs = datepart( second, @c_time) + @c_secs/1000
select @new_cmd = @rs_ticket_param + ";RDB(" + db_name()
+ ")=" + convert( varchar(2), datepart( hour, @c_time))
+ ":" + convert( varchar(2), datepart minute, @c_time))
+ ":" + convert( varchar(6), @c_secs)
insert ticket_history values (@c_time, @new_cmd)
end
go
rs_ticket_report is invoked by the function string rs_ticket_report if dsi_rs_ticket_report is set to on.
rs_ticket_param is written to Replication Server log when print_rs_ticket is on.
Customize rs_ticket_report to parse and process rs_ticket_param.
rs_ticket, rs_ticket_report function string
