Hope this will help you.
This Solution will help for less tables
1.Create a Table with following columns
TableName : LastUpdateTableInfo
1.Id - primary key(Auto generate)
2.TableName
3.UpdateDate
2.Create the AfterUpdate Trigger for each tables
use [DatabaseName]
Go
create trigger trgupdatetableInfo on [TableName]
for update
as
declare @tableName as varchar(50)
declare @lastUpdateTime as varchar(50)
set @tableName =[yourtablename]
set @lastUpdateTime= GETDATE()
insert into dbo.LastUpdateTableInfo (tablename,UpdateDate) values (@tableName,@lastUpdateTime)
Go
Now whenever update happens the mention table will log the info .
You can get the last update table name by supply the following Query
SELECT [Id]
,[TableName]
,[UpdateDate]
FROM [placeDB].[dbo].[LastUpdateTableInfo] order by Id desc