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

Home

Author

Message

Posted Monday, January 25, 2010 5:00 AM

Old Hand

Group: General Forum Members
Last Login: Thursday, May 23, 2013 10:41 PM
Points: 310, Visits: 649

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

Group: General Forum Members
Last Login: Thursday, June 13, 2013 8:32 PM
Points: 700, Visits: 1,009

MSreplication_subscriptions

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

Post #852937

Posted Monday, January 25, 2010 8:48 AM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 10:32 AM
Points: 11, Visits: 229

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

Group: General Forum Members
Last Login: Thursday, May 23, 2013 10:41 PM
Points: 310, Visits: 649

Oh thanks

Post #854098

Permissions