[thelist] MSSQL - list of 'date last updated' for all tables in a db?

Canfield, Joel JCanfield at PacAdvantage.org
Tue Jan 10 13:50:43 CST 2006


Is it possible to view or output the 'last updated' date for all the
tables in a MSSQL db? I'm merging two databases, and one has 100 tables,
nearly all of which are never used.

I think.

Other than querying each table individually and looking for the most
recent updated record, is there a better way?

thanks

joel



More information about the thelist mailing list