April 12, 2010 at 6:20 am
Hi,
How to get the transaction log details like who enters in to the server, in which login, What transaction he did...?
Please help because i need to track these details
Thanks in Advance
April 12, 2010 at 7:34 am
You can read the log with some undocumented commands such as DBCC LOG, but it is very hard to understand the output (I tried it long time ago and gave it up). There are some third party tools such as SQL Log Rescue or Log Explorer that you can use in order to view the error log and even undo some of the transactions, but they are not so cheap. You can also check the option of using server’s tools such as profiler, server side trace or C2 audit (depending on your needs).
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply