Transactional Replication Report

  • Good Day ,

    I need to generate a report of the row counts of every replicated table on the Publisher and compere the results of this report with the row counts of the subscriber and combine both reports into a single report . As we have multiple databases that are replicated we need to combine the replication reports of all the replicated databases into a single report . Preferably in Excel. Any Ideas ? Ps. we re not allowed Linked servers.

  • This sounds like a job for SSIS!

    @=)

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

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

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