SQL Server Performance
preethi
Last activity:
Jan 16, 2013
Joined:
Jul 27, 2007
Messages:
488
Likes Received:
1
Trophy Points:
18
Gender:
Male
Birthday:
May 7
Home page:
Location:
Colombo, Sri Lanka
Occupation:
Senior DBA Lead

Share This Page

preethi

Member, Male, from Colombo, Sri Lanka

preethi was last seen:
Jan 16, 2013
    1. Bhavani
      Hi Preethi, I'm struggling hard to get few data about replications could you please help me out. I would like to know how to identify the list of DB's on a servers which are subscribed. I'm not even able to identify whether a SQL server has any subscriptions. I want system Stored procedure which returns this information, not by looking into the Object Explorer.
      1. preethi
        preethi
        check sys.databases for the following columns: is_published, is_subscribed, is_merge_published & is_distributor. These columns are self explaining
        Objects in msdb, distribution & publisher DBs
        Please search for replication in books online for further detail.
        Please be more specific. I prefer public forum; it allows many to learn & share.
        Oct 3, 2011
      2. preethi
        preethi
        this private message is limited. Please ask from public forum
        Oct 3, 2011
  • Loading...
  • Loading...
  • Signature

    Cheers,
    Preethiviraj Kulasingham
    http://preethiviraj.blogspot.com

    Plan your work and work your plan!

    About

    Gender:
    Male
    Birthday:
    May 7
    Home page:
    http://preethiviraj.blogspot.com
    Location:
    Colombo, Sri Lanka
    Occupation:
    Senior DBA Lead