rs_helpcheckrepdef

Displays the replication definitions that exist only to define primary key columns, and quoted table or column names.

Syntax

rs_helpcheckrepdef [replication_definition]

Parameters

replication_definition – specify replication definitions with names that start with the text you entered.

Examples

Example 1 – suppose there are two replication definitions defined for a primary Replication Server:

authors – only specifies primary key information:

create replication definition authors
        with primary at NY_DS.pdb1
        (au_id varchar(11),
        au_lname varchar(40) ,
        au_fname varchar(20) ,
        phone char(12),
        address varchar(40),
        city varchar(20),
        state char(2),
        zip char(5),
        contract bit)
        primary key (au_id)

titleauthor – specifies different target column names in addition to the primary key:

create replication definition titleauthor
        with primary at NY_DS.pdb1
        (au_id varchar(11) as author,
        title_id varchar(6) as title,
        au_ord tinyint,
        royaltyper int)
        primary key (au_id, title_id)

If you enter rs_helpcheckrepdef at the RSSD or ERSSD of the primary Replication Server, you see:

Replication Definition Name
---------------------------
authors                                                                        

(1 row affected)
(return status = 0)

Usage

Execute rs_helpcheckrepdef at the RSSD or ERSSD of the primary Replication Server .
If you do not enter any text for replication_definition, rs_helpcheckrepdef lists all replication definitions that exist only to define primary keys, and quoted table or column names.
If you enter any text for replication_definition, rs_helpcheckrepdef lists all replication definitions with names that start with the text you entered for replication_definition, and that exist only to define primary keys, and quoted table or column names.
Once RepAgent starts sending the primary key and quoted identifier information, you can drop the replication definitions identified by rs_helpcheckrepdef.