How to know Subscription is PULL or PUSH in SQL Server 2005

• sqlquery-101401

  SSCarpal Tunnel

  Points: 4951

  More actions

  July 29, 2008 at 8:20 am

  #382044

  In SQL Server 2000 replication under Publication folder on right panel column 'Type' i was able to see if it is 'PULL' or 'PUSH' but same i am not able to see in SQL 2005 , can any body confirm where and How i can see the subscription is PULL or PUSH in SQL Server 2005?

  Appreciate your reply.

• jeffrey yao

  SSCarpal Tunnel

  Points: 4365

  More actions

  July 30, 2008 at 5:54 pm

  #850931

  Check BOL sp_helpSubscription

  In the return set, there is a column called "Subscription type", 0 = push, 1=pull, 2=anonymous

  HTH,

  J.Y