Sql Ce Replication information

[Steve B.]

Hi,

I use Sql Ce 2.0 with merge replication.

Is there any way to determine which tables are concerned with a given
replication ?

I did not find any usefull information in INFORMATION_SCHEMA.*

Thanks,
Steve

 

[Marius Bucur]

Hi,
you can use sysmergearticles table.
Marius

 

[Steve B.]

I do not understand the structure of this table...

I have two replications in my application.
I want to know wich tables are replicated with repl1, and which with
repl2...

Steve

 

[Sergey Bogdanov]

You can find description of all fields in this table here:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sys-m_70hf.asp

 

[Marius Bucur]

In sysmergepublications there are all publication of the database, to find
tables for a plublication join
sysmergepublications and sysmergearticles on pubid.
Marius

 

[Steve B.]

Ok, but this on the SQL Server 2000, not subscriber (sql ce).

I need to determine which tables are related to one replication ON the
device (because of some cache mecanims, I need clear objects related to one
table when the table is replicated)

Steve

 

[Marius Bucur]

Sql Server CE 2.0 supports only one subscription per database. So if a table
is replicated it is member of a single publication.
When replication is performed you can't control witch tables are replicated
(all tables in subscription will be replicated) so you should invalidate
cache for all tables involved in replication.

I don't know a method to determine what tables form a sql ce database are
member of a subscription but I think is safe to assume that tables that have
columns s_Generation and s_RowLineage are replicated.

Marius