sql server data warehouse: time stamp magicaly updated when ever update event occures on a row -- sql server data warehouse

time stamp magicaly updated when ever update event occures on a row

Daniel
12/8/2005 3:12:21 PM

sql server data warehouse: time stamp magicaly updated when ever update event occures on a row

in sql server 2000 i have a table. when i do any update on the table, a
field of the effected rows gets a new time stamp, there are no triggers on
the table, nothing special in the DDL of the table, is there any other way
besides a table specific trigger that this time stamp could be getting
updated when i do an update on a row? perhaps some other kind of trigger
that is not specific to a table but specific to a fielde name in any table?

Re: time stamp magicaly updated when ever update event occures on a row

MC
12/9/2005 12:00:00 AM

This is the way the timestamp is supposed to work. It should get changed
whenever theres a data change in the same row. The engine handles that part.

MC

[quoted text, click to view]