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