How to confirm if the replication is using Push/Pull subscription?

• SQL_Hunt

  SSC-Dedicated

  Points: 33486

  More actions

  June 17, 2022 at 5:27 pm

  #4051103

  Hello,

  On an existing configured replication setup, how to confirm if it's using a Push or Pull subscription? Basically working on setting up a similar replication in a new server, but am unable to find the details of the existing legacy server's configuration!

  Thanks.

• ScottPletcher

  SSC Guru

  Points: 100262

  More actions

  June 17, 2022 at 9:57 pm

  #4051205

  In the distribution db, query view dbo.syssubscriptions

  SQL DBA,SQL Server MVP(07, 08, 09) "Money can't buy you happiness." Maybe so, but it can make your unhappiness a LOT more comfortable!

• June 20, 2022 at 6:57 am

  This was removed by the editor as SPAM

• June 23, 2022 at 6:15 am

  This was removed by the editor as SPAM