SQL Server - 检索数据库中每个表的最后一条记录

I am looking for the last record entered in each table of the database. I know how to return the last record for each table one at a time. However, I need to loop through all the tables (about 10,000) and find the last record posted. I can do this by scripting (i.e. get all tables into an array and then doing a for each). I am looking for the last record entered in eac