David,

One idea would be to add an Insert,Update,Delete (or you could break it up into three to determine when the last, Insert, Update, or Delete was done.) trigger to the table you would like to know this info, use the SQL GETDATE() function to store the current system date in a different table that you can query later.

John

>Now, however, I'm working with a SQL Server application. I don't know the application well, so, after I perform some function with it, I want to know what tables were updated - either delete, adds or changes.
>
>I would think this would be easy in SQL Server 7, but I can't figure it out. I can't find any system stored procedures, system tables etc. that store this.
>
>Thanks in advance for your help.
>
>David Schlesinger