Hi virtualjosh,

I'd be very careful using the sys.tables.modify_date field.

In my experience, it is not always kept up to date in realtime.

For example, try the following:

CREATE TABLE test1 (i INT, vc1 VARCHAR(10))

SELECT modify_date FROM sys.tables WHERE name='test1'

INSERT test1 VALUES (1, 'row1')

SELECT modify_date FROM sys.tables WHERE name='test1'

The values returned are the same....(?)

Regards,

Lawrence