Post reply

list articles in a subscription

  • February 21, 2012 at 4:03 pm

    #256202

    hi guys, is there a way to list all articles that are in a SUBSCRIPTION. I have some articles that i removed from subscriptin and not publication. i know i can run sp_helparticle to get list of all publicaton's articles. i have transaction replication.

  • February 21, 2012 at 6:20 pm

    #1450043

    i got it sp_helpsubscription

    http://msdn.microsoft.com/en-us/library/ms190493(v=sql.90).aspx

    🙂

  • February 22, 2012 at 11:40 am

    #1450487

    It's more useful to understand how SQL stored replication information. This is what I would use.

    select *

    from syssubscriptions ss with(nolock)

    inner join sysarticles sa with(nolock) on sa.artid = ss.artid

    inner join syspublications sp on sp.pubid = sa.pubid

    inner join sys.servers sss with(nolock) on sss.server_id = ss.srvid

    where sp.name = '' and

    ss.srvname = ''

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply