rs_idnames

Stores the names of Replication Servers and databases known to the ID server. rs_idnames table is relevant only at the ID Server site.

Column

Datatype

Description

name1

varchar(30)

Replication Server or data server name

name2

varchar(30)

Database name; “” for a Replication Server

type

int

Replication Server or database:

  • 8 – Replication Server

  • 9 – database

id

int

Unique ID assigned to the Replication Server or database

ltype

char(1)

The type of the database:

  • P – Physical database

  • L – Logical database

Indexes

Unique clustered index on (name1, name2, ltype)