Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2003

    Question 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?

    Thanks Ed

  2. #2
    Join Date
    Nov 2002
    Structure changes or data cheanges.

    If they're changing the structure I think it's a much bigger deal....

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    May 2004
    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.

  4. #4
    Join Date
    Jul 2003
    Thanks I thik I'll go with the trigger solution, Thanks Ed

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts