How to determine what was inserted

Hi,
Can anyone tell me how I can locate what was inserted into the publisher?
The merge agent on the publisher says Last Action (Merged 3 data chnages (3
inserts, 0 updates, 0 deletes, 0 resolved conflicts) Further along the
merge agent details reveal that it was 3 Publisher inserts.
I want to know what was inserted (At least what table was affected).
Is this possible.
PS: I only have access to the Publisher.
Can anyone help?
Hi Warren,
From your descriptions, I understood that you would like to find out what
was done by Replication when it reminds you 3 inserts etc., Have I
understood you? If there is anything I misunderstood, please feel free to
let me know
Unfortunately, I don't think there are any views or tables will record this
kind of modifications. Only possible way is using SQL Profiler to trace the
operation of Replication so that I believe you will find them.
Hope this helps and if you have any questions or concerns, please feel free
to let me know. I will be glad of assistance!
Sincerely yours,
Mingqing Cheng
Microsoft Online Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
|||Hi Mingqing,
Thats exactly what i want to know (What tables were affected by the inserts,
updates etc)
I will try the profiler if I can, but we are concerned by the extra time
Replication will now take.
Many thanks
Warren
""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
news:YGlFkACUEHA.2988@.cpmsftngxa10.phx.gbl...
> Hi Warren,
> From your descriptions, I understood that you would like to find out what
> was done by Replication when it reminds you 3 inserts etc., Have I
> understood you? If there is anything I misunderstood, please feel free to
> let me know
> Unfortunately, I don't think there are any views or tables will record
this
> kind of modifications. Only possible way is using SQL Profiler to trace
the
> operation of Replication so that I believe you will find them.
> Hope this helps and if you have any questions or concerns, please feel
free
> to let me know. I will be glad of assistance!
>
> Sincerely yours,
> Mingqing Cheng
> Microsoft Online Support
> Get Secure! - www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>

How to Delete Data on the Subscriber but Maintain It on the Publisher?

Hi,
We're using merge replication between a Sql Server 2000 Publisher and
Subscribers on PocketPCs running Sql Server Ce.
One part of our data sync scheme deals only with newly created data on
the PocketPC. For this we have an upload-only replication that sends
the new data from the device to the Publisher.
Due to storage constraints on the PcketPC, we want to delete the data
from these SQL CE tables after it has been sent to the Publisher, but I
am assuming that if we do so, upon the next replication this data will
then be deleted from the Publisher also.
We want to avoid that from happening - we want to delete the data on
the subscriber after it has been merged, but we also want to maintain
the data on the publisher.
Is there any way that we can delete the data from the subscriber but
still maintain it on the publisher.
Thanks,
JJ
create a sql account which has rights to insert and update, but not delete
on your publisher. Add this to the pal, and use this account in your SQL CE
program in the PublisherLogin parameter.
Now, for the articles which you wish the deletes not to make it to the
publisher, right click on the publication, select publication properties,
and then click on the articles tab. Click on the browse button to the right
of your table names, and select the merging changes tab. Ensure the delete
command is selected.
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
"JJ" <jjabour@.gmail.com> wrote in message
news:1127612785.479827.68040@.o13g2000cwo.googlegro ups.com...
> Hi,
> We're using merge replication between a Sql Server 2000 Publisher and
> Subscribers on PocketPCs running Sql Server Ce.
> One part of our data sync scheme deals only with newly created data on
> the PocketPC. For this we have an upload-only replication that sends
> the new data from the device to the Publisher.
> Due to storage constraints on the PcketPC, we want to delete the data
> from these SQL CE tables after it has been sent to the Publisher, but I
> am assuming that if we do so, upon the next replication this data will
> then be deleted from the Publisher also.
> We want to avoid that from happening - we want to delete the data on
> the subscriber after it has been merged, but we also want to maintain
> the data on the publisher.
> Is there any way that we can delete the data from the subscriber but
> still maintain it on the publisher.
> Thanks,
> JJ
>