Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
COMMANDER
Starting Member
6 Posts |
 Posted - 2010-01-29 : 03:19:50
|
| Hii have more than 40 Merge replication installed all of the subscribers are on one same serverand the publishers are on different remote serversis there any log table or log File for the replication in which failure or success of Synchronization is registered????i know i can create alerts and send emails in case of agent failurebut i need to create a report that shows which regions are operational and which regions are failingThanks in Advance |
|
|
COMMANDER
Starting Member
6 Posts |
Posted - 2010-01-29 : 06:37:48
|
| i found MSrepl_errors Thanks |
 |
|
|
SreenivasBora
Posting Yak Master
164 Posts |
Posted - 2010-02-02 : 09:14:07
|
| Select * from Distribution.dbo.MSrepl_errors where xact_seqno is not nullWith RegardsSR |
|
|
|
|
|
|
Monitoring and detecting Replication Failures