>Thanks for all replies,
>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 ?
>
>TIA

You might also search for SQL-DMO in the BOL. It's a COM interface that can let you programmatically do things like add and modify triggers, SPs, etc.