>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.
George
Ubi caritas et amor, deus ibi est