Read log file sql server 2005

Lynn - Sorry, I should have posted this first instead of just saying "I found it! They're visible through Management Studio as you described, but they're just text files errorlog, errorlog. Please could you in the future post new questions in new threads? Sometimes people don't look at old threads cause they think they're 'solved'. You must be logged in to reply to this topic. Login to reply.

April 7, at pm April 8, at am If you have the log or log backups , you can download Log Rescue from Red Gate and use that. April 8, at pm Hi , Thanks for your reply. Brian Kelley kbriankelley.

Hi Brian, Thanks for the reply. April 9, at am There's no good way to do this in without buying the software. October 3, at am I haven't tried that part of it yet.

August 12, at am Nowadays, Ex-employees or hackers intentionally modifies the values of databases in order to damage the organization assets. And it becomes difficult to analyze or examine who is the culprit manually. As a result, the Organizations run into big trouble.

In short, with SQL Log file, it becomes easy to find out which query performed on which table at what time. Here, we are going to answer how to view log file of SQL Server by using various workarounds. In the following section, you will understand how to open, check and read transaction file to retrieve information about the data which had been altered. Basically, this method exclusively used to open and view the information about following logs in SSMS:.

In fact, one can open the Log File Viewer wizard in different ways on the basis of information that you want to check. Now, go through the instructions to view log details in SQL Server. Step 2: Connect to Server windows pops-up. Learn more. Asked 11 years, 11 months ago. Active 8 years, 3 months ago. Viewed 7k times. John Saunders k 25 25 gold badges silver badges bronze badges. IordanTanev IordanTanev 5, 3 3 gold badges 37 37 silver badges 49 49 bronze badges.

If you don't mind, why do you need do that? This seems a wrong way to anywhere You don't find any examples because this isn't something you should be doing. I know at first look it seems wrong to read this file but i am trying to do something like the SQL Log Rescue but i need to implement it as part of bigger program so i need to know how htey read the file i cant just use the progrma — IordanTanev.

Add a comment. Active Oldest Votes. Andrew Andrew Iza Pastoor Iza Pastoor 1 1 silver badge 4 4 bronze badges. I don't understand why do you need to implement this, but seems wrong, at least.

This option is far more simple than what you proposed and can be achieved in a documented way. Rubens Farias Rubens Farias