Changing login timeout and Query time out setting for Log Reader Agent in Enterp
I have set up Transactional Replication between two databases on two different
servers.
Log Reader Agent status Initializes and goes into Retrying mode. As a result
of which the
Data is not getting transferred across the database.The SQL server error
log says that the
Sp_repldone stored procedure could not be executed .Has some come across
Retrying mode of Log Reader Agent
I execute the sp_repltrans and got to know that there are a few transaction
are currently not distributed.
I executed EXEC sp_repldone @xactid = NULL, @xact_segno = NULL, @numtrans
= 0, @time = 0, @reset = 1
Still the status of Log Reader Agent is in Retrying mode.
Any settings to be done . Please suggest
How can I change the login timeout and Query time out setting for Log Reader
Agent in Enterprise manager.
Not finding any example(Query) in books on line
Thanks

