Post reply

Check for Replication tables

  • August 28, 2011 at 3:39 am

    #247090

    Hi,

    What is the system table where I can see what are the databases enabled for replication?

    Thanks,

    Ravi

  • August 28, 2011 at 7:53 am

    #1374288

    RaviShankar1234 (8/28/2011)

    What is the system table where I can see what are the databases enabled for replication?i

    I would use sp_msforeachdb querying syspublications, sysarticles and syssubscriptions system tables

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  • August 28, 2011 at 2:18 pm

    #1374327

    sys.databases has a column called is_published for those databases that are enabled for replication.

  • August 28, 2011 at 4:17 pm

    #1374342

    Thanks, Paul and Rookie

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

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