Script to find tables that are modified/updated from last N days

Question

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

GregoryF SSCertifiable Points: 6296 More actions · Answer 1

In SQL 7 or 2000 the only way to do it would be to:

1) Create a new table with [table_name], [last_update], [last_insert], [last_delete]

2) Create a trigger on the source tableto update the new table

or

Add a new field to the existing table with last_updated/when_inserted

There is no intrinisc way to tell when a table was changed, short of restoring the the DB as an alternate DB and replaying the logs.

/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!

John Paul-702936 SSCrazy Points: 2182 More actions · Answer 2

Actually , not for a single table ..

I am trying to find List of the tables names in the database ..

That was modified/Updated from last N days ..

In 2005 We can use modified_date from sys.objects ..

But .. How can get the List of table names in SQL 200

GregoryF SSCertifiable Points: 6296 More actions · Answer 3

SQL 2000 does not have that functionality

/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!

John Paul-702936 SSCrazy Points: 2182 More actions · Answer 4

thanks ...

Is there any way to find all the DTS packages that depends on this Server(machine)..

Thanks