Post reply

Repl Transaction history for an article

  • October 15, 2009 at 8:51 am

    #205638

    Hi,

    I have a requirement to identify the last few transactions happened through replication on a specific table/article. Please help me whether it is possible to retrieve in SQL 2005

    Thanks in Advance.

  • October 21, 2009 at 1:50 am

    #1068702

    On the distribution server, get the value of srvid from master..sysservers which corresponds to the publisher. Next, get the article id from the msarticles table in the distribution database. Then get the value of id from the mspublisher_databases table in the distribution database where publisher_id = the value of srvid.

    Then run sp_browsereplcmds @publisher_database_id = <id from mspublisher_databases>,@article_id = <your value>

    Rows will be returned with the oldest transaction first.

    Hope that helps,

    Mike

  • October 22, 2009 at 9:37 am

    #1069493

    Thanks a lot ! One more clarification. How long will this history be retained? when i checked i dont see any histories for any of the articles... When exactly this history gets cleared...

    Thanks in Advance...

  • October 22, 2009 at 10:32 am

    #1069540

    it will clean up every after "Distribution clean up: distribution” job runs.

    http://www.replicationanswers.com/TransactionalOptimisation.asp

    HTH

    Vinay

    Thanx.
    Vinay

    http://rdbmsexperts.com/Blogs/
    http://vinay-thakur.spaces.live.com/
    http://twitter.com/ThakurVinay

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

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