Unanswered: local access to replication logs (was "Does anyone have a clever solution")
We have a SQL Server database that runs a website on our server, however the company that we are running the website for requested that they have a replicated local version at their business. Everything is working fine.
However they have requested that they have access to the replication logs. They want to have the details of the recent replication details so they can see if changes they have made on their side has been transferre across successfully they also want a table with all the details in of the changes that have ever happened. Can anyone suggest a good way of doing this?
I've had to do the same thing at my company, what I did was put triggers on the replicated tables (on the subscriber side). The triggers wrote all insert/updates into a "Log" table which our customer could access throgh Crystal reports.