I am new to SQL2K8 replication. I have been reading lots of articles/tutorials on this subject. I was able to setup a Transactional Replication. Everything is working as expected. However, I wanted to further investigate as
to what events are taking place behind the scene just to educate myself a bit more.
I found that in the process of creating my transactional replication, it created the "Distribution" database under the "System Database" node on my SQL 2008 box. There is only one table called "UIProperties" with a column called ID. My question
is where is the Log Reader keeping the changes in my publications. I can see when I made a change to a row in my publication, it got replicated to the subscription database. But where is SQL Server storing these changes?? I guess when the
distribution agents runs, where does it get the changes from? From my reading, the Distribution database is supposed to keep tracking of these changes. But I am finding any changes I made to my publication. Can someone educate me on
View Complete Post