Results 1 to 3 of 3
  1. #1
    Join Date
    May 2004
    Location
    Seattle
    Posts
    1,313

    Unanswered: replication related questions

    I have a couple questions about replication (for both 2000 and 2005 servers):

    1. which system tables/dmvs/system sprocs can I look at to determine which columns of a table are being replicated?

    2. which system tables/dmvs/sprocs can I call to get metadata about publishers and subscribers?

    Thanks!

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    1. None of them, since Microsoft changes the table structures and internal details from time to time, and emphatically does NOT guarantee anything about those tables. The sp_helparticlecolumns stored procedure will give you this information though, in a supported fashion too!

    2. Again, none, for the same reason. There are more choices for stored procedures here, can you give an example of what information you're trying to retrieve?

    -PatP

  3. #3
    Join Date
    May 2004
    Location
    Seattle
    Posts
    1,313
    I think I need to do some reading myself first.

    These questions are actually straight from a customer of mine who wants me to add documentation of replication related stuff to sqlspec. I've never used replication before so I thought I'd ask here. Premature.

    thanks though. I'll come back when I have done my homework!

Posting Permissions

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