Checking Replication Programatically

  • On many occasions, I have been asked to find out if a table or table(s) have been replicated to various servers.  This is a tedious task.  Is there a way, using t-sql, that I can check if a table has been published for replication and get eh name of the publication as well as the subscribers of that publication? (BTW -  I am new to the administration side of SQL Server but experienced in the programming side)

    Thanks.

    David

    Kindest Regards,
    David

    ** Obstacles are those frightening things that appear when we take our eyes off the goal. **

  • Try posting this in the Replication forum.

    maybe one of the mods will move this to the Replication forum thread...

    http://www.sqlservercentral.com/forums/messages.aspx?forumid=7

  • I'll do that as well.  Thanks.

    Kindest Regards,
    David

    ** Obstacles are those frightening things that appear when we take our eyes off the goal. **

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

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