Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2004
    Posts
    101

    Unanswered: Replication query

    Hi,
    Does anyone has a query to get the replicaiton - pulication, subscription and article information.

    Im looking for the following information..

    Publication Type Publisher Subscriber Table(s)
    Employee Trans Server1 Server2 db1.dbo.table1
    Server3
    Server4

    Any feedback is much appreciated.

    Thanks

  2. #2
    Join Date
    Jan 2004
    Location
    In a large office with bad lighting
    Posts
    1,040
    Did you try scripting the publication?

    -- This is all just a Figment of my Imagination --

  3. #3
    Join Date
    Apr 2004
    Posts
    101
    Nevermind..i was able to retreive information by joining these tables on distribution server.

    select * from MSpublications (nolock)
    select * from MSsubscriptions(nolock)
    select * from MSsubscriber_info(nolock)
    select * from MSarticles(nolock)
    select * from MSpublications (nolock)
    select * from master..sysservers(nolock)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •