Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Last time a table was updated?
Message
De
31/03/2000 15:08:46
 
 
À
31/03/2000 08:22:16
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Divers
Thread ID:
00353240
Message ID:
00353576
Vues:
21
Too bad... :(

Thanks for your input, Mike!




>Not to the best of my knowledge.
>
>I can see two solution. First, have a trigger that update's a timestamp in another table. The problem is that you've now introduced a hotspot. All transactions are trying to achieve a lock on this other table.
>The second, is to store a last-update value on each row and update it with a trigger.
Sylvain Demers
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform