Replication Production issue,Urgent please help!!

Question

I have sql server 2005, I am having an issue where the transactions are sitting at the distributor and not going to subscriber.
And I am seeing a pending status under distributor to subscribur. This replication is a continuous Transactional replication
and not updatable.

Please help!!

---

sqldev

Answer 1

What is the exact error message you are getting and where do you see it?

---

looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941

Answer 2

you should run the following statement

use distribution

go

select * from msrepl_errors order by 2 desc

there you should see the error. Then with the transaccion id (xact_id I guess) use it for the next statement

sp_browsereplcmds '[xact_id]'

there you should see the pending replication commands