Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

DATABASEPROPERTYEX and the IsSubscribed property Expand / Collapse
Author
Message
Posted Wednesday, April 10, 2013 9:15 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, August 14, 2014 3:50 AM
Points: 282, Visits: 441
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
Post #1440875
Posted Thursday, April 11, 2013 2:41 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 12:07 AM
Points: 868, Visits: 2,775
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

@SeanPearceSQL

About Me
Post #1441138
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse