SQL Server logs 1

[Wyldcard9]

We are running a Kovis system with our SQL Server. Kovis has its own DB with tables. Only select users(managers) can change certain data. One of our tables has the lookup data. One of those types got changed, and none of the managers remembers changing it. I need to track who did it, and when. Any ideas?

I have already left a message with the Kovis techs. I am assuming that SQL Server logs every action somewhere. I just need to find that place.

 

[mrdenny]

All the actions are stored in the Log files. Get Lumagent's SQL Log Explorer. It will let you view the log files, and roll back the transaction if needed.

Denny

--Anything is possible. All it takes is a little research. (Me)

 

[Wyldcard9]

mrdenny,

Thanks. I will see if I can get managament to swing for buying that. What if I wanted to view the log files manually?

 

[mrdenny]

You can't. The files are not in a readable format, not to mention that you would have to shutdown the SQL Server in order to read the file. SQL Server keeps the files locked so that nothing else can access them while SQL is running.

Denny

--Anything is possible. All it takes is a little research. (Me)

 

[Wyldcard9]

mrdenny,

Gotcha thanks. Well I had one manager step forward and admit to making the change. Kinda funny how they remembered after I explained IT had to buy another product, and I needed to spend time working on it.

 

[Wyldcard9]

BTW it is Lumigent.

 

[mrdenny]

Thanks. Spelling never has really been my strong point.



Denny

--Anything is possible. All it takes is a little research. (Me)

 

[Wyldcard9]

mrdenny,

Not a problem

I talked to my manager after downloading the trial version. He choked at the price of a license. So I thought about it some more, and realized that the SQL Table is being updated from the Kovis software. That table does not have a field for userID, and update date. However other tables they have, does have those two fields for tracking purposes. Since their software updates the table, I made the request to have them add those two fields to that table, and update them. Now I could add those two fields to the table myself, but without getting into their software(not open source, so I can't), I won't be able to have it update those two fields each time it updates the table entries.

Hopefully in a future software release. I am also keeping the total users/managers who have access to this program very low.

 

[mrdenny]

That should also work for a solution.

Denny

--Anything is possible. All it takes is a little research. (Me)