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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Daniel - 08 Dec 2005 23:12 GMT

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?

Reply to this Message

MC - 09 Dec 2005 07:21 GMT

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

> time stamp magicaly updated when ever update event occures on a row
>
[quoted text clipped - 6 lines]
> that is not specific to a table but specific to a fielde name in any
> table?

Reply to this Message