For details about SQL Server Auditing, please refer to the following article.
https://docs.microsoft.com/en-us/sql/relational-databases/security/auditing/sql-server-audit-database-engine
https://www.codeproject.com/articles/166264/audits-on-ms-sql-server
Alternatively, you may try this automated solution (

Below articles can help you to create required server audit and specifications:

https://docs.microsoft.com/en-us/sql/relational-databases/security/auditing/create-a-server-audit-and-server-audit-specification

https://docs.microsoft.com/en-us/sql/relational-databases/security/auditing/sql-server-audit-database-engine

https://tabledependency.codeplex.com/wikipage?title=SqlTableDependency

Alternatively, you may...

You can follow the below links to capture the row counts for all tables in a database.

http://msdn.microsoft.com/en-us/library/bb510625.aspx

http://www.mssqltips.com/sqlservertip/2537/sql-server-row-count-for-all-tables-in-a-database/

Express12 (7/9/2014)

---

Need recommendations on a good, easy to use --- SQL Server AUDITing tool... to capture many facets of who did what, when, how.. yaddy ya...

(I recently...