PDA

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