When working with an application that uses VFP local tables, determining what the last update date/time is for a given table is easy - just do a dir in VFP or DOS and look at the file save date.

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