>>Hi Using MM.NET 3.6 with C#, ASP.NET and SQL Server 2008 R2.
>>
>>I need to track all changes made to the database. There is no budget for a third party tool so I am looking for something free that will give me the ability to track changes made to all or selected tables, knowing who made the change (using the ID of the currently logged in MM.NET user). I will then need to run queries/reports against this data to answer questions like, "Who made this change when?".
>>
>>I've found a few articles on SQLServerCentral.com and am reading through them now (for example: http://www.sqlservercentral.com/articles/SQL+Puzzles/anaudittrailgenerator/2067/ but I'm not sure how to adjust that to store the MM.NET user id) and will do some more Googling, but was wondering if anyone here could recommend a solution.
>
>Check http://msdn.microsoft.com/en-us/library/cc280386.aspx and also http://social.msdn.microsoft.com/Forums/br/transactsql/thread/95cf87fa-85f4-45e2-bad2-7f489d3f7662
>
>However, both solutions are for Enterprise version of SQL Server, AFAIK.

Thanks Naomi,

I should have mentioned that I am using the Express version but will have a look anyhow