Ok but the problem is that i have more then 100 tables to audit and check so creating a trigger or CDC is not really a good option.

What is the best practice to use an audit for these 100+ tables without creating commands for every table (perhaps there is an option or a tool that allows me to monitor all the tables on a database and save in case of any insert/update/delete...)

thank you for your help.