Post reply

Findout the type of replication Pull or Push

  • April 28, 2015 at 3:39 pm

    #303381

    Hi,

    SELECT

    P.Publication

    ,P.Publication_type

    ,S.Subscriber_ID

    ,S.Update_Mode

    FROM MSPublications P

    INNER JOIN MSSubscriptions S

    ON P.Publication_ID = S.Publication_ID

    give me publication_type=0. So it is transactional replication but how do we know that is pull or push?

  • April 28, 2015 at 3:46 pm

    #1794132

    The MSsubscriptions table has a column:

    subscription_type

    that identifies which it is.

    SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

  • April 29, 2015 at 10:07 am

    #1794391

    Thank you.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply