rs_publications

Stores information about publications known to this Replication Server.

Column

Datatype

Description

prsid

int

Primary Replication Server where the publication was created

pubname

varchar(255)

Name of the publication

pubid

rs_id

Unique publication ID

pdbid

int

Unique ID for the publication’s primary data server and database

requestdate

datetime

Date and time the last article was added to the publication

ownerid

rs_id

ID of the user who created the publication

status

int

Publication status:

  • 0x00 – Invalid

  • 0x01 – Valid

minvers

int

Minimum Replication Server version required to support this publication

Indexes

  • Unique clustered index on (pubname, pdbid)

  • Unique index on (pubid)