Subscriptions to table replication definition

[Former Member]

is there any way to check if a table-level (not database-level) replca definition has subscriptions.

[former_member89972]

Yes. in RSSD or eRSSD

1. First

execute rs_helpreptable <DBName>, <TableName>

This will show the repdefs for that table.

2. Then for each repdef

execute rs_helprep <repdef_name>

At the bottom of the output it will show you the subscription name(s) for that repdef

3. You can also further check about where the replicated data is going

execute rs_helpsub <repsub name>

HTH

Avinash

See the attachment for examplerepdef-and-repsub-for-a-table.txt

[Former Member]

I already have de replication definitions for the tables, but I can´t see subscriptions on them. And

What strikes me most is that the databases are replicated at the database level, but also have table replication definitions. Maybe was doing for eficiency.

I will follow the steps you mention

Thanks a lot for your help