October 28, 2011 at 7:24 am
According to BOL (any version), the Category column in sysDatabases holds flags indicating a database's involvement in replication. This is certainly true for publishers, but does anyone know why a database subscriber to merge replication articles would have a Category code of 0 ? (the replication is working fine), based on BOL I would have expected either 2 or 8 for a subscriber.
Phil
November 24, 2011 at 2:59 am
I don't have an answer to your question, but I have a question since you are asking this question in a SQL Server 2008 forum. What is the value of the is_subscribed column in sys.databases for the database in question?
November 25, 2015 at 5:34 pm
Here you go:
0x1: Published for snapshot or transactional replication
0x2: Subscribed to a snapshot or transactional publication
0x4: Published for merge replication
0x8: Subscribed to a merge publication
0x10: Functions as a distribution database
November 25, 2015 at 5:45 pm
caa (11/25/2015)
Here you go:0x1: Published for snapshot or transactional replication
0x2: Subscribed to a snapshot or transactional publication
0x4: Published for merge replication
0x8: Subscribed to a merge publication
0x10: Functions as a distribution database
Well, getting an answer after four years is better than never getting an answer.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply