• USE distribution

    GO

    SELECT * FROM dbo.MSsubscriptions

    subscription_type Column;

    0 = Push.

    1 = Pull.

    2 = Anonymous.