Categories: MSDN / DotNet / Java / Scripts / Linux / PHP Ask - La ask - La Answer

Changing login timeout and Query time out setting for Log Reader Agent in Enterp

Hi ,
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
[925 byte] By [Mahesh DK] at [2007-11-9 21:10:17]