DATABASEPROPERTYEX and the IsSubscribed property

• Rin Sitah

  SSCrazy

  Points: 2180

  More actions

  April 10, 2013 at 9:15 am

  #292081

  Hi All,

  When trying to examine if a database is a subscriber, I am trying to use DATABASEPROPERTYEX like:

  select DATABASEPROPERTYEX ( 'SubscriberDB' , 'IsSubscribed' )

  but it always returns 0, regardless of if the DB is a subscriber or not.

  Is there something i'm missing?

  Cheers.

  Rin

• Sean Pearce

  SSCoach

  Points: 15999

  More actions

  April 11, 2013 at 2:41 am

  #1605485

  That property (and the column in sys.databases) does not work. You can check the distribution database for that info.

  SELECT

  *

  FROM

  distribution..MSsubscriptions

  WHERE

  subscriber_db = 'SubscriberDB';

  

  The SQL Guy @ blogspot[/url]

  @SeanPearceSQL

  About Me[/url]