Post reply

Replication Monitoring in SQL server 2005

  • January 11, 2011 at 11:28 am

    #232040

    can anyone suggest me script for creating DTS package or JOB which can give me count of source and destination tables raw count in transactional replication under sql server 2005...

  • January 11, 2011 at 7:30 pm

    #1272157

    I assume that you are really trying to make sure that replication is operating correctly. You can get replication to do the hard work for you. It can be used to validate the each subscription by do row counts and checksums.

    Try right clicking on a publication in Management Studio - have a look at "Validate Subscriptions..." and see if that does what you need.

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

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