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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-10-09 : 10:13:53
|
| Ravichandran.V writes "hi! I have studied about SQL Server, an every action on a Database such as INSERT,UPDATE and DELETE to a particular table, Before updating the original database this command updated into LOG file(in .LDF format). So that we are doing an every action on a particular table, its also helped to increase the size of that log file.Now my question is Can i see what are all the action happend for a particular table by the particular user from certaine date to certain date form LOG file?. If it is possible, Give me the solution. with regards Ravichandran.V" |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2002-10-09 : 11:31:10
|
| Is it possible? No ... at least not without some 3rd party tools ... see Lumigent or others.If auditing changes in a business need, you should probably consider creating an audit system based on triggers or maybe a profiler trace ...Jay White{0} |
 |
|
|
|
|
|
About LOG File