Post reply

Viewing sql 6.5 article properties

  • August 20, 2003 at 2:20 am

    #84124

    Hello all,

    I am currently trying to reproduce a SQL 6.5 replication setup on SQL2000.

    The SQL6.5 is a production setup and currently replicating to clients. What

    I need is to view the details of each publication and article, however when

    I get down to article level in Enterprise Manager the properties are greyed

    out and the scrollbar disabled. The only way I know to view the article

    properties is to unsubscribe the publication, but as this is a production

    server I am unwilling to do this.

    Any ideas?

    Thanks in advance

    Chris

  • August 20, 2003 at 3:54 am

    #470551

    Hello again,

    After some more searching around I have found the following stored procedures that will give me what I need

    sp_helparticle

    sp_helparticlecolumns

    sp_helppublication

    Thank you to anybody who looked into it for me.

    Chris

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

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