Dear All,
I want to Monitor a table or multiple table activities with the follwing
results.
1. Previous Value
2. New Value
3. Table Row Changed
Thanks in advance
Hi,
You have write your own triggers for Insert and Update actions.
Thanks
Hari
MCDBA
"Syed Zulfiqar" <zulfiqar_syed@.hotmail.com> wrote in message
news:OB4LyN#FEHA.3188@.TK2MSFTNGP10.phx.gbl...
> Dear All,
> I want to Monitor a table or multiple table activities with the follwing
> results.
> 1. Previous Value
> 2. New Value
> 3. Table Row Changed
> Thanks in advance
>
|||THere is also a tool that Lumigent makes which analyzes the T-Log, etc which
( I beleive) can do what you wish... Integra ( www.lumigent.com)
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Syed Zulfiqar" <zulfiqar_syed@.hotmail.com> wrote in message
news:OB4LyN%23FEHA.3188@.TK2MSFTNGP10.phx.gbl...
> Dear All,
> I want to Monitor a table or multiple table activities with the follwing
> results.
> 1. Previous Value
> 2. New Value
> 3. Table Row Changed
> Thanks in advance
>
|||I have just been playing around with the demo if this software and it seems
really good. Certainly look slike it will save me the many hours of
building an audit trail into my application!
"Wayne Snyder" <wsnyder@.computeredservices.com> wrote in message
news:OmW4dk%23FEHA.576@.TK2MSFTNGP11.phx.gbl...
> THere is also a tool that Lumigent makes which analyzes the T-Log, etc
which
> ( I beleive) can do what you wish... Integra ( www.lumigent.com)
>
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Computer Education Services Corporation (CESC), Charlotte, NC
> www.computeredservices.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Syed Zulfiqar" <zulfiqar_syed@.hotmail.com> wrote in message
> news:OB4LyN%23FEHA.3188@.TK2MSFTNGP10.phx.gbl...
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment