Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to tell when a Sql database has been updated
Message
General information
Forum:
ASP.NET
Category:
Coding, syntax and commands
Miscellaneous
Thread ID:
01489725
Message ID:
01489737
Views:
55
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform