|
Home > Archive > MS SQL Data Warehousing > December 2005 > time stamp magicaly updated when ever update event occures on a row
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
time stamp magicaly updated when ever update event occures on a row
|
|
| Daniel 2005-12-08, 8:23 pm |
| 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?
| |
|
| 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
"Daniel" < softwareengineer9803
7@yahoo.com> wrote in message
news:OLw76yE$FHA.4028@tk2msftngp13.phx.gbl...
> 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?
>
>
|
|
|
|
|