Read data from log file???

Question

Read data from log file???

sol.nt

SSCrazy

Points: 2062
More actions
February 1, 2007 at 9:36 pm

#116101

Hi all
Is there anyway to read data from log file to know who is Insert, Update or delete one row with time it was exec .... ?
Anything is welcome: T-SQL , tools , ... ...etc but i'd like it is T-SQL ...
Thanks and Regards

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Minaz Amin SSChampion Points: 11052 More actions · Answer 1

Hi,

SQL Profiler will be helpfull as it audit security events and audit events. Security events include database access and data access.

We will be able to view which users access the database.

SQL Profiler can also supports auditing the actions performed on instances of SQL Server and meets C2 security certification requirements. SQL Profiler provides the user interface for auditing events. There are several categories of events that can be audited using SQL Profiler, these include end user activity; DBA activity; security events; utility event; server events and audit events.

BOL:

Auditing SQL Server Activity

Minaz Amin

"More Green More Oxygen !! Plant a tree today"

sol.nt SSCrazy Points: 2062 More actions · Answer 2

Thanks.

But do you know another way to read info from log file (*.ldf) or how to know exactly who is the one insert , update or delete record on a table when statement was execute and just by T-SQL, not tools. Because, I would like to know who is change my data and when.

Regards.

Minaz Amin SSChampion Points: 11052 More actions · Answer 3

DBCC log ( {dbid|dbname}, [, type={-1|0|1|2|3|4}] )

PARAMETERS:

Dbid or dbname - Enter either the dbid or the name of the database

in question.

type - is the type of output:

0 - minimum information (operation, context, transaction id)

1 - more information (plus flags, tags, row length, description)

2 - very detailed information (plus object name, index name,

page id, slot id)

3 - full information about each operation

4 - full information about each operation plus hexadecimal dump

of the current transaction log's row.

-1 - full information about each operation plus hexadecimal dump

of the current transaction log's row, plus Checkpoint Begin,

DB Version, Max XDESID

by default type = 0

To view the transaction log for the master database, you can run the

following command:

DBCC log (master)

More info follow this link : http://www.databasejournal.com/features/mssql/article.php/1442251#part_2_8

Minaz Amin

"More Green More Oxygen !! Plant a tree today"

sol.nt SSCrazy Points: 2062 More actions · Answer 4

Thanks your advise .

I will see how i can get what you said.

Thanks again.