August 28, 2011 at 3:39 am
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
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
sys.databases has a column called is_published for those databases that are enabled for replication.
August 28, 2011 at 4:17 pm
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