How to get modified time of a table

Hello All,

I would like to get last modified timestamp for a table. Is there any way to
get that information using any commands?

Thanks in Advance,
Muthu.Muthu (muthuviji.k@.gmail.com) writes:

Quote:

Originally Posted by

I would like to get last modified timestamp for a table. Is there any
way to get that information using any commands?

No, there is no built-in support for this. You could have to add
a modified_date column to the table, and then use a trigger to ensure
that it's updated accordingly.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||>I would like to get last modified timestamp for a table. Is there any way to get that information using any commands? <<

Before you send your boss to jail, you might want to look at SOX rules
for audits. Then look at third party tools for such things.