Home > SQL Server Replication > Transactional Replication Information (Publisher–Publication-Articals–LogReader)

Transactional Replication Information (Publisher–Publication-Articals–LogReader)

I have created a script  to get all replication information about Publisher,Publication,Articals and LogReader in a treeview Structure .Like How many publisher withsnapshot location,how  many publication are generated from each of the publisher,How many articals are associated with each publication ,Log Reader Agents associated with each publication with LodReader Agent Job information. I will write more about Replication Type,SyncType,Subscription Type etc in my next blog post or in the same one.

Script: Download the script and run the Script at Distribution Database

Run this script if u have SQL Server 2005 or above.

Download : Replication_Info_Script – V3

Download :Replication_Info_Script – V2

Download : Replication_Info_Script



Update  :  Added Subscription Information

Update : Added Distributor Information

  1. msufian
    January 20, 2011 at 12:59 pm

    Bug has been identified in the code.. I will be updating the script soon.. there is no harm in running the script on the prodcution .. As i have tested the same in UAT and also use the same script in the Prod Env.

  2. msufian
    January 20, 2011 at 5:58 pm

    Bug fixed….. the value of the below variable was previously set to 1 .
    DECLARE @Publication_id varchar(10)
    DECLARE @publisher_id varchar(10)

  3. msufian
    January 23, 2011 at 10:21 am

    In process of upgrading the script to add subscription and Distribution agent information.

    If u guys have any suggestion please let me know.

  4. Aijaz Khan
    August 23, 2011 at 6:22 pm

    Hi Mohammed,
    Your script is a piece of work 
    However I like to know if you can provide a script which will show a list of each table in a subscription and when was the last time the table replicated. I have 2005 and 2008.
    Thanks in advance.


    • msufian
      August 24, 2011 at 3:54 am

      Will respond to your query in few days as i am travelling (going to my parental home for Eid).


  5. Aijaz Khan
    August 24, 2011 at 7:48 pm

    Thanks Sufin. I am celebrating in US.

    Eid Mubarak to you and your family:)

    • Aijaz Khan
      September 16, 2011 at 3:30 pm

      Hi Mohammed,

      Any update on my request please????

      • msufian
        September 29, 2011 at 6:04 pm

        Hi Aijaz,

        Was bit busy , insha allah will send you the script by monday.

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: