Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
wided
Posting Yak Master
218 Posts |
 Posted - 2012-02-02 : 05:28:37
|
| Hi!what is the way to read the log file from SQL 2005 or 2008thanks |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2012-02-02 : 08:22:51
|
| select * from fn_dblog(<start lsn>,<end lsn>)It's not documented at all, neither are many of the operations and it's not designed to be human-readable. What's the reason for this request?--Gail ShawSQL Server MVP |
 |
|
|
wided
Posting Yak Master
218 Posts |
Posted - 2012-02-02 : 08:43:52
|
| thank you reason is a change of data was made. I want to know who did it and when The log can give me this information?thank you reason is a change of data was made. I want to know who did it and when The log can give me this information? |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2012-02-02 : 09:27:59
|
| Maybe, but the log is not an audit log, it's there for database integrity. It doesn't store the operations in an easy-to-understand way, and it does not store logins, host names or anything else you need from an audit.--Gail ShawSQL Server MVP |
|
|
|
wided
Posting Yak Master
218 Posts |
Posted - 2012-02-02 : 09:37:53
|
| I was told that there is a complementary tool for SQL Server that allows that. you know, what's his name?thanks |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2012-02-02 : 10:11:13
|
| Nope, there's no free log reader for SQL 2005 (there was one for SQL 2000, but it does not work on SQL 2005 or above). Log readers typically start around $1000 per license.--Gail ShawSQL Server MVP |
|
|
|
wided
Posting Yak Master
218 Posts |
Posted - 2012-02-02 : 11:44:17
|
| thanks,I m from TunisiaGood night |
|
|
|
|
|
|
SQL LOG FILE