Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
How can I get last update date for a table in sql server 7
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement