MS SQL Server - SQL Server

Author

SQL Server - data audit log

TheMaxx

2006-10-31, 12:15 am

I need to trace all changes in my DB tables. (insert, update delete, delete
cascaded records etc...)
I do not want to create paralel tables with history (even though that is
exactly precision that i need)
Is there a way to use Transaction log for this purpose?

Hilary Cotter

2006-10-31, 12:15 am

With tools like Log Explorer you can do this.

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

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

"TheMaxx" <themaxxREMOVE@net.hr> wrote in message
news:ei57nh$7vb$1@ma
gcargo.vodatel.hr...
>I need to trace all changes in my DB tables. (insert, update delete, delete
>cascaded records etc...)
> I do not want to create paralel tables with history (even though that is
> exactly precision that i need)
> Is there a way to use Transaction log for this purpose?
>

Hari Prasad

2006-10-31, 12:15 am

Hi,

Logexplorer wil be good tool...See the details from below URL

http://www.lumigent.com/products/le_sql.html

Thanks
Hari

"TheMaxx" <themaxxREMOVE@net.hr> wrote in message
news:ei57nh$7vb$1@ma
gcargo.vodatel.hr...
>I need to trace all changes in my DB tables. (insert, update delete, delete
>cascaded records etc...)
> I do not want to create paralel tables with history (even though that is
> exactly precision that i need)
> Is there a way to use Transaction log for this purpose?
>

Sponsored Links