Do you know how to audit records in Sql Server ?
Check out this post for details -
https://www.sudshekhar.com/blog/how-to-audit-records-in-sql-server