Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Last time a table was updated?
Message
From
31/03/2000 15:08:46
 
 
General information
Forum:
Microsoft SQL Server
Category:
Other
Miscellaneous
Thread ID:
00353240
Message ID:
00353576
Views:
15
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
Previous
Reply
Map
View

Click here to load this message in the networking platform