Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to tell when a Sql database has been updated
Message
Information générale
Forum:
ASP.NET
Catégorie:
Code, syntaxe and commandes
Divers
Thread ID:
01489725
Message ID:
01489737
Vues:
53
>Hi.
>ny quick way to tell when a table (or any data) in a Sql Server table has been updated with data.
>If I add a few records to a table, the Date Modified flag does not seem to get updated on the .MDB file
>
>regards,
>Gerard

Check sys.tables system table. It does have modified date field. See last script in this blog post How to list information about all databases without a loop
If it's not broken, fix it until it is.


My Blog
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform