I'm looking for a way to log File Access on our FileServer to an SQL-server, because I don't want to have the information in the eventlog.
Is this as easy as I would have thought it would be, or am I venturing into dangerous territory. I have never logged to an SQL-server, so I don't know what I should look into. If there is a simple program for doing this instead, alternatively to another Database, that's just as fine, All I want is a system that allows me to go in and say, who accessed this file on the fileserver at that day and keep the logging for a long time, 1 year - 5 year... depending on the diskspacerequirement.
I'm not prepared to invest a lot of money in this, but if there is a smart program that can fullfill my requirements easily, that's fne by me too.
Let me know what you think/know already :)