System Tables Map for Replication

Question

Does anyone know if there is an equivalent of the replication system tables map below for 2005?
http://www.microsoft.com/sql/prodinfo/previousversions/systables.mspx

The only system views map I can find is this one:
http://www.microsoft.com/downloads/details.aspx?FamilyID=2ec9e842-40be-4321-9b56-92fd3860fb32

but it doesn't include the replication tables.

Thanks.

Answer 1

Hi, JWOL,
            Not sure if this is what you want?
            http://msdn.microsoft.com/en-us/library/ms179855(SQL.90).aspx

Thanks

Gary

Answer 2

It was a map that I was after, rather than a list of tables.  There was one for SQL 2000, but I can't find one for SQL 2005.

Answer 3

Sorry, but I don't think an updated map (poster) of the replication tables was created for SQL Server 2005.  The only one that I am aware of is the general system catalog views that you have already seen.

Regards,
Gail

---

Gail Erickson [MS] This posting is provided "AS IS" with no warranties, and confers no rights

Answer 4

Hi JWOL,

i am ot sure about your requirement.
You can do this by creating a user table and populating them through a SP/Job from system tables annd then use it.

Let us know in case you have any further questions on this.

Please Vote & "Mark As Answer" if this post is helpful to you.

Cheers
Bikash Dash
MCDBA/MCITP

 

Answer 5

I'm looking for a PDF or a document similar to this: http://www.microsoft.com/sql/prodinfo/previousversions/systables.mspx that maps out the replication system tables and their relationships.  I'm not sure I understand how I can create a user table and populate it with a stored procedure to do this.