How to get MS SQL 2000 Table last modified date ? [Archive]

View Full Version : How to get MS SQL 2000 Table last modified date ?

albanello

12-25-2005, 08:06 AM

Hi
Can anyone tell me how to get the Last Modified Date for a table in MS SQL 2000. I found the Creation Date (crdate) but can not find the date the table in my database was last modified.

Thanks
albanello

joelnet

12-26-2005, 10:00 AM

Most applications I've seen use a DateTime column in the database to determine when it has been modified.

Joel Thoms

DiscountASP.NET
http://www.DiscountASP.NET