Home Forums SQL Server 2005 SQL Server 2005 General Discussion Erwin: propagate comments to multiple tables. RE: Erwin: propagate comments to multiple tables.
aaron.reese
SSChampion
Points: 13498
More actions
March 3, 2010 at 10:51 am
#1127946
Are you saying that you want a single table that holds
TableName, DateLastModified
If so, then one way would be to add a trigger to every table that you require to be logged to create or update the record in the LastUpdate table.