Wednesday, March 28, 2012

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!
>

No comments:

Post a Comment