• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 156
  • Last Modified:

How to identify a database is configured for replication or not?

I would like to identify my DB is subjected to or configured for replication. How to achieve it? Please suggest.
0
Easwaran Paramasivam
Asked:
Easwaran Paramasivam
1 Solution
 
Anthony PerkinsCommented:
I suggest you look at the sys.databases catalog VIEW.  Specifically the following:
select name, is_published, is_subscribed, is_merge_published, is_distributor
FROM sys.databases 

Open in new window

0
 
Easwaran ParamasivamAuthor Commented:
Thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now