This is a discussion on time stamp magicaly updated when ever update event occures on a row within the SQL Server Data Warehousing forums, part of the Microsoft SQL Server category; --> time stamp magicaly updated when ever update event occures on a row in sql server 2000 i have a ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| 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" <softwareengineer98037@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? > > |