How can I find the changes that happened to all tables in last hour in Microsoft SQL Server? For example if a new record added I can find it with its ID or if a record deleted or update too.
I want to find them that I write a script to copy them to a new server. I have different servers that I want to write all changes to a server that it contains all of data.
If somebody has a better idea how to do it, it would be great if you would tell me, thanks.