Showing posts with label action. Show all posts
Showing posts with label action. Show all posts

Friday, March 30, 2012

How to develop a program which can monitor the change of a table content?

I need this exe program to monitor the insert and update action of a
table in SQL Server 2000 initiatively
How to delevop this program?
Who can provide me some advice or some information?
Thanks a lot.This is a multi-part message in MIME format.
--=_NextPart_000_0051_01C3CAB1.5A9963D0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
See my reply in .programming.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
.
"Simon Peng" <pengxq@.hotmail.com> wrote in message
news:tpcluvo1vuac96vtrplv36sndhoiheg9ck@.4ax.com...
I need this exe program to monitor the insert and update action of a
table in SQL Server 2000 initiatively
How to delevop this program?
Who can provide me some advice or some information?
Thanks a lot.
--=_NextPart_000_0051_01C3CAB1.5A9963D0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

See my reply in =.programming.
-- Tom
----Thomas A. =Moreau, BSc, PhD, MCSE, MCDBASQL Server MVPColumnist, SQL Server ProfessionalToronto, ON Canadahttp://www.pinnaclepublishing.com/sql">www.pinnaclepublishing.com=/sql.
"Simon Peng" wrote in =message news:tpcluvo1vua=c96vtrplv36sndhoiheg9ck@.4ax.com...I need this exe program to monitor the insert and update action of =atable in SQL Server 2000 initiativelyHow to delevop this program?Who can =provide me some advice or some information?Thanks a lot.

--=_NextPart_000_0051_01C3CAB1.5A9963D0--|||Why dont you use triggers to audit the table|||sysindexes table records all update, insert, delete activity for all tables. this may work for you. check it out.sql

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