CODEWITHSUNDEEP
sql-serverdatabasesybase
Amir Borzoei
Amir Borzoei

Reputation: 680

Can I trace database's records by SQL query from log file?

I need to trace changes on a record in database. I have some triggers on different tables that calls one stored procedure and this sp updates records in certain table (table1).

I will trace records in table1 to find when and from where data are changed.

Actually I use sybase 12.5 and I would know how to read LOG file by SQL query in sybase or sql server.

tanx :)

Upvotes: 0

Views: 727

Answers (2)

SergeyKazachenko
SergeyKazachenko

Reputation: 66

I think pretty much the only way to track changes is to write a trigger...

Upvotes: 0

Tamil.SQL
Tamil.SQL

Reputation: 262

I don't think we can read transaction log using sql query unless there is some tools like Fog Light

As far as I know we can use DBCC command

DBCC LOG([,{0|1|2|3|4}])

0 - Basic Log Information (default)

1 - Lengthy Info

2 - Very Length Info

3 - Detailed

4 - Full

Also if this is gonna be permanent scenario, I would create a history table to audit update and delete changes. Hope I helped, sorry if I don't answer your question.

Upvotes: 1

Related Questions