How do I find a table that was just updated?

[TonyScarpelli]

I am trying to find a table that was just updated in a database. The database has many tables and I am looking for what table was updated and what associated tables were updated.

Is there a way to tell what table in a database was just updated or had a row inserted?

Thanks.

Tony Scarpelli
Clinical Engineering Dept.
Maine Medical Center
Portland, Maine 04102

 

[ptheriault]

No there is not. You would need to create your own Audit table and use triggers to track that informaion.

- Paul

- If at first you don't succeed, find out if the loser gets anything.