Use the list parameter with sp_replication_path at the primary database to display information on bindings and replication objects.
sp_replication_path dbname, 'list', ['object_type'], ['object_name']
sp_replication_path 'pdb','list' go
Binding Type Path -------------------- -------- -------------------- dbo.dt1 T everywhere dbo.sproc1 P pdb_1 dbo.sproc1 P pdb_2 dbo.t1 T pdb_2 dbo.t2 T pdb_1 (5 rows affected) Logical Path Physical Path ---------------------------- --------------------- everywhere pdb_1 everywhere pdb_2 (2 rows affected) Physical Path Destination ------------------------------ ------------------- pdb_1 RS2 pdb_2 RS1 (2 rows affected) (return status = 0)
sp_replication_path 'pdb','list','table' go
Binding Type Path -------------------- -------- -------------------- dbo.dt1 T everywhere dbo.t1 T pdb_2 dbo.t2 T pdb_1 (3 rows affected) (return status = 0)
sp_replication_path 'pdb','list','sproc' go
Binding Type Path -------------------- -------- -------------------- dbo.sproc1 P pdb_2 dbo.sproc1 P pdb_1 dbo.sproc2 P pdb_1 (3 rows affected) (return status = 0)
sp_replication_path 'pdb','list','sproc','sproc1' go
Binding Type Path -------------------- -------- -------------------- dbo.sproc1 P pdb_2 dbo.sproc1 P pdb_1 (2 rows affected) (return status = 0)
sp_replication_path 'pdb','list','path' go
Path Type Binding -------------------- -------- ---------------------- everywhere T dbo.dt1 pdb_1 P dbo.sproc1 pdb_1 T dbo.t2 pdb_2 P dbo.sproc1 pdb_2 T dbo.t1 (5 rows affected) Logical Path Physical Path ----------------------------- ------------------------ everywhere pdb_1 everywhere pdb_2 (2 rows affected) Physical Path Destination ----------------------------- ---------------------- pdb_1 RS2 pdb_2 RS1 (2 rows affected) (return status = 0)
sp_replication_path 'pdb','list','path','everywhere' go
Path Type Binding -------------------- -------- ------------------------- everywhere T dbo.dt1 (1 rows affected) Logical Path Physical Path ----------------------------- -------------------------- everywhere pdb_1 everywhere pdb_2 (2 rows affected) Physical Path Destination ----------------------------- ------------------------- pdb_1 RS2 pdb_2 RS1 (2 rows affected) (return status = 0)
sp_replication_path 'pdb','list','path','pdb_1' go
Path Type Binding -------------------- -------- -------------------- pdb_1 P dbo.sproc1 pdb_1 T dbo.t2 (2 rows affected) Physical Path Destination ------------------------------ ------------------- pdb_1 RS2 (1 rows affected) (return status = 0)