I am new with SQL database, I am build some Automation Tool in MS-Excel , which can read and write data in database contain 160 tables, this database is also write and read by other software(X).
my task is find all changes are done by other software(X), in database table. so same think I can be done with excel.
Practically It is hard to check one by one 160 table.
I really appreciate for help, I was Google on it but not found so much. sorry if any mistake in my question.
You can use SQL Server Change Tracking in SQL Server 2008 Express Edition. See Features Supported by the Editions of SQL Server 2008 R2.