October 13, 2005 at 12:34 am
Hi all
can any one tel me how to read any information from the database transaction log file
October 13, 2005 at 1:42 am
You should take a look at 3rd party tools such as Log PI or Lumigent Log Explorer.
October 13, 2005 at 2:07 am
thanks chris but i wanna do it my self throw the sql server
October 13, 2005 at 2:50 am
Well there is no supported way of doing this. The log file format is proprietary to Microsoft and it is not documented. There is an undocumented command to output some information regarding the log. The syntax is:
DBCC log ( {dbid|dbname}, [, type={-1|0|1|2|3|4}] )
But I doubt it will help you much. Why do you need to read the log?
October 13, 2005 at 5:49 am
What exactly do you want to "read" from the log - do you want to know what people have changed (like an audit trail?)
October 14, 2005 at 9:06 am
There is also the log reader function, again undocumented:
select * from ::fn_dblog(@@dbid,null)
Dylan Peters
SQL Server DBA
October 15, 2005 at 12:32 am
i wanna know every change on my database so i can audit any time and corect any problem
October 15, 2005 at 12:52 am
In that case, there was an article posted in the last week or so that gave many ideas (as well as its following discussion where even more ideas were presented) on simple ways to audit all changes to data in all of your tables... I would suggest you look at the article - a quick search of the site would find it.
October 15, 2005 at 3:14 am
Either that, or simply use one of the 3rd party tools mentioned above. Then you will not need to audit constantly and decrease performance. But you cannot do it with some undocumented command or something, it is as simple as that.
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply