Check for Replication tables

  • Hi,

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

    Thanks,

    Ravi

  • 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.
  • sys.databases has a column called is_published for those databases that are enabled for replication.

  • 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