Queue Reader Agent Failed -- sql server replication

Chinnappa Rajesh
10/18/2006 9:16:01 PM

Hi,

We have set replication between two servers.In subscriber if i update any
row, the transaction is in Msreplication_queue Table.But when it try to push
to publisher it throws a error called "Invalid cursor state". I don't know
where it is going wrong.
what could be the cause of this error.

Thanks in Advance,
Rajesh

Chinnappa Rajesh
10/19/2006 2:09:02 AM

Hi

Thanks, Currently we have installed SP3.We have to install it.

[quoted text, click to view]

Paul Ibison
10/19/2006 9:36:20 AM

Do you have sp4 installed? There was a bug prior to sp4 which gave this
message (http://support.microsoft.com/kb/831997/EN-US/).
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server replication

sql server replication : Queue Reader Agent Failed