DATE & TIME OF REPLICATION OF DATA

Hi,
I have 20 databases in merge replication between local & remote server.
I need the date & time to know when that particular change is replicated.
is it possible?
& what is use of the column rowguid can we get any information from this?
Thanks,
Soura
You would have to do something like this
select coldate from MSmerge_genhistory,msmerge_Contents where
MSmerge_genhistory.generation=msmerge_Contents.gen eration
and convert(varchar(36),rowguid)='F0AE2ED2-5FDC-4013-8079-00BC00C37A4A'
The rowguid column is used to identity which row has changed. Each row has a
different value for the rowguid and this value will be global across your
replication solution. So if your first row in the authors table had a value
of 11111111-1111-1111-1111-111111111111, the first row in each of your
subscribers will also have this same value.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"SouRa" <SouRa@.discussions.microsoft.com> wrote in message
news:292732AF-103D-4F4C-8DB5-774C8E5D3B76@.microsoft.com...
> Hi,
> I have 20 databases in merge replication between local & remote server.
> I need the date & time to know when that particular change is replicated.
> is it possible?
> & what is use of the column rowguid can we get any information from this?
> Thanks,
> Soura