SQL Server Performance

Script to display the List of Publication, Articles and its job

Discussion in 'SQL Server 2005 Replication' started by gb2000, Sep 7, 2007.

  1. gb2000 New Member

    Can some one help me to get the list of Publication, Articles , Type of Replication and its corresponding job by providing a sql script.
    Thanks in advance.
    Also where I would be able get the system view of distribution database.
    gb2000, Sep 7, 2007
    #2

  2. ndinakar Member

    Check out syspublications, sysarticles etc in the publication database.
    ndinakar, Sep 7, 2007
    #3

  3. dineshasanka Moderator

    u can find all the system tables related to replication from BOL at
    ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/5696ee73-5d7c-4f26-b7ee-6831c9c3edf7.htm
    dineshasanka, Sep 9, 2007
    #4

  4. satya Moderator

    As referred you could refer to the updated books online for HOW TO : replication topics in this case, moreover for the scripts you can run PROFILER while monitoring the same using Replication monitor and SSMS.
    satya, Sep 10, 2007
    #5

Share This Page