How to trace all changes made in certain DB for today?

[olegkot]

Hi!

How to trace all changes made in certain DB for today?
I need to see actually all changes trought all tables of the certain DB.

Can somebody help? I'm complitely new in SQL.

thx in advance, oleg.

 

[tlbroadbent]

SQL Server provides no audit trail that you describe. You can do the following.

1) Write triggers to record updates in audit tables. This is a very commonly used procedure.

2) Use SQL Profiler to create trace(s). Store the output of the trace(s) in tables for later analysis.

3) Buy third party Audit software. A web search should find a few available packages. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[goatstudio]

You can see a rough log file under
Management -> SQL Server Logs

This is not a detail log for your SQL Server. ------------------
Freedom is a Right

 

[sguslan]

There are nice products that help explore the database log.
Visit

http://www.sqlcentral.com

for details on many products that you may find helpful.

Also read about the Log Explorer at:

http://www.lumigent.com/