Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Null Foreign Keys
Message
From
04/08/2015 01:42:06
 
 
To
03/08/2015 03:57:04
General information
Forum:
Microsoft SQL Server
Category:
Database design
Environment versions
SQL Server:
SQL Server 2012
Application:
Desktop
Miscellaneous
Thread ID:
01622856
Message ID:
01622905
Views:
55
>
>I would have guessed your ordered preferences to be SP, trigger, application, but interpret the above otherwise? No worry about clock differences between client machines?

Good point. I hadn't listed them in any specific order. My personal is a trigger (or even Change Data Capture), as that is the absolute full-proof method of ensuring that ALL updates get posted with a last update, if any of the before/after values actually changes.
Previous
Reply
Map
View

Click here to load this message in the networking platform