Post reply

Showing list of changes made to subscriber or publisher

  • April 10, 2005 at 8:26 pm

    #85792

    Hi all,

    Wondering if and where tables or logs of changes made to data in tables is in SQl server 2000 ?

    Or do we have to identify the changes ourselves,

    I know how to find out how many changes were made, but would like to know what changes were made, even if it was just a row id etc

    I havent come across where to find this information in BOL or web or on the db.. any help is much appreciated.

     

    Thanks

     

    Adam


    ------------------------------
    Life is far too important to be taken seriously

  • April 12, 2005 at 3:20 pm

    #552255

    For Transactional:

    Have a look  at sp_browsereplcmds

    For Merge thereis an script by Paul Ibison posted here

    HTH


    * Noel

  • April 12, 2005 at 5:47 pm

    #552267

    Thanks for the reply, I omitted to say what type of replication may be required., Im actually looking for merge which based on the link provided looks very useful

    will let you know if this is what im looking for, thanks very much for the response!


    ------------------------------
    Life is far too important to be taken seriously

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply