system table that can inform whether the subscription is Push or Pull

• luckysql.kinda

  SSCertifiable

  Points: 7816

  More actions

  January 25, 2010 at 5:00 am

  #209369

  There is a system table that can inform whether the subscription is Push or Pull. I forgot that table name. Can anyone tell?

  Lucky

• Daveee

  SSCommitted

  Points: 1600

  More actions

  January 25, 2010 at 5:52 am

  #1108089

  MSreplication_subscriptions

  http://msdn.microsoft.com/en-us/library/ms190485.aspx

• Rohan Joackhim

  Old Hand

  Points: 391

  More actions

  January 25, 2010 at 8:48 am

  #1108193

  USE distribution

  GO

  SELECT * FROM dbo.MSsubscriptions

  subscription_type Column;

  0 = Push.

  1 = Pull.

  2 = Anonymous.

• luckysql.kinda

  SSCertifiable

  Points: 7816

  More actions

  January 26, 2010 at 9:10 pm

  #1109046

  Oh thanks