>but i dont need very professional solution, is there any way to add triggers for auditing to each table on sql server and keep logs on another table ?Soykan,
That's basically what we do in our VFP app. We have one stored procedure that does the storing in the audit table and each trigger of each table calls this procedure.
For SQL Server, you can probably use a similar approach and even write a T-SQL script that creates all the triggers for each table so you don't have to manually do it.
If you're not familiar with SQL Server triggers or T-SQL stuff, you should really sit down and review the SQL Books Online help.
Laterness,
Jon
Jon Rosenbaum
Devcon Drummer