Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

system table that can inform whether the subscription is Push or Pull Expand / Collapse
Author
Message
Posted Monday, January 25, 2010 5:00 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, September 11, 2014 12:39 PM
Points: 310, Visits: 659
There is a system table that can inform whether the subscription is Push or Pull. I forgot that table name. Can anyone tell?

Lucky
Post #852926
Posted Monday, January 25, 2010 5:52 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Tuesday, June 3, 2014 7:32 PM
Points: 700, Visits: 1,029
MSreplication_subscriptions

http://msdn.microsoft.com/en-us/library/ms190485.aspx
Post #852937
Posted Monday, January 25, 2010 8:48 AM


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, March 14, 2014 9:11 AM
Points: 12, Visits: 237
USE distribution
GO
SELECT * FROM dbo.MSsubscriptions

subscription_type Column;


0 = Push.

1 = Pull.

2 = Anonymous.


Post #853053
Posted Tuesday, January 26, 2010 9:10 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, September 11, 2014 12:39 PM
Points: 310, Visits: 659
Oh thanks
Post #854098
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse